Depends whether each column has a separate index on it, or all columns are
in a single concatenated index. An IOT is like the latter - it's only going
to help if you are always using the same (or similar) access path.
Oracle doesn't go to a table if it can get all the values it needs from an
Its one index with all the columns. This is why I was thinking it would
be the same or similar performance. The execution path is fine and
considering how many rows I am dealing with the execution is more then
fine. I was trying to reduce storage and speed up the loads a bit.
-Original
Kimberly - Have you considered making this an index-organized table?
Available in the most recent versions of Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 25, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Its one
That is my whole question. I did make it an IOT and performance
suffered. I was surprised by that.
-Original Message-
Sent: Thursday, October 25, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
Kimberly - Have you considered making this an index-organized table?
Available in
Title: RE: Weirdness
First off... Did you place a separate index on every column or one index that included every column? Second, either of those is methods is probably overkill... The real questions you have to ask are...
Have you determined the execution plan of the statement yet?
What