With Oracle 9i, the Cost-Based Optimizer (CBO) is equipped with many useful features, one of them is "Index skip scan". In previous releases a composite index could only be used if the first column, the leading edge, of the index was referenced in the WHERE clause of a statement. In Oracle 9i this restriction is [...]
http://feedproxy.google.com/~r/viralpatelnet/~3/4UUNoJ1xM5s/
No comments:
Post a Comment
If you have any question please let me know