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 was it with the IOT?
What was it with your indexing solution?
What columns are joined in the query you are talking about?
What was the definition of the IOT you created?
What was the definition of the segments in the Table with Index method?
You need to figure out what the query needs to accomplish and either rewrite the query to be more efficient or place the proper index or indexes to improve your performance...
HTH
Tim
-----Original Message-----
From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Weirdness
Oracle 8.1.7.1 on HPUX 11
I have a table that I have just indexed every column. This has improved the
query performance however, its going to slow down the load. Thing that has
me confused is that I tried this as an IOT and it actually hurt performance.
This table is joined to another table 3xs. The table I made an IOT has >2
million rows and the other table has >6 million rows. Shouldn't the IOT
table have had similar performance to having every column indexed?
________________________________________
Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
