Search SSWUG.ORG:



DATABASES

Oracle 11g and Index Access This is an off-site link.  Please review our Terms of Service for additional information.




(David Fitzjarrell) In a forum I frequent a question was raised regarding an index not being used. The poster is using Oracle 11.1.0.7, which limits the index access paths Oracle can use; a concatenated index is created on the table (which has columns x,y,z,t,q and w, for lack of better names) on columns x, y, and z.

Read this article...







comments powered by Disqus