indexing - SQL/Oracle: when indexes on multiple columns can be used -


if create index on columns (a, b, c), in order, understanding database able use if search on (a), or (a , b), or (a , b , c), not if search on (b), or (c), or (b , c). correct?

there 3 index-based access methods oracle can use when predicate placed on non-leading column of index.

i) index skip-scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#pfgrf10105

ii) fast full index scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#i52044

iii) index full scan: http://download.oracle.com/docs/cd/b19306_01/server.102/b14211/optimops.htm#i82107

i've seen fast full index scan "in wild", possible.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -