| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 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:kimberly.smith_at_gmd.fujitsu.com]
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?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Oct 24 2001 - 15:43:34 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |