Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: indexing "select" columns
Your query is going to use the INDEX - it is 100%.
If you have any question, let me know
Good Luck
chan
OCP DBA
lrzhemov_at_home.com (Leon) wrote in message news:<8cb139cf.0106041232.192801d6_at_posting.google.com>...
> I hope Oracle would use only index to select information from the
> table as soon as all information is present in an index, so
> select col2
> from table1
> where col1= value
> would use only index as soon as index
> CREATE UNIQUE INDEX12 ON table1(COL1, COL2)
> exists
> Unfortunately statistics for select like that shows that speed of this
> query is exactly the same as with index "CREATE UNIQUE INDEX1 ON
> table1(COL1)"
>
> Does anybody has good experience in using "index only" (simulating
> IOT) queries?
> Potentially it should be faster then IOT as soon as indexes could be
> cached in memory but IOT can't.
>
> Thanks
> Leon
Received on Tue Jun 05 2001 - 07:49:07 CDT