Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> link between parsing time and number of indexes on a table
Environment: Oracle 8.0.6 on AIX
On a table containing 3 million rows and around 10 columns, the parsing time for a SQL statement (select a single row using unique index) goes from 0.06s if there is only one index on the table to 1.40s if there are 5 indexes on the table.
Parsing time are similar if :
+ optimizer_mode=choose, there are compute statistics on table and
indexes
+ optimizer_mode=rule, there are compute statistics on table and indexes + optimizer_mode=choose, there are NO statistics on table and indexes + using hint /*+ index(message iu_message_1) */
==>Is that a normal behavior of Oracle to take at least 1s to parse a
basic statement on a table with 5 index?
Do you know any workaround to decrease the parsing time in this case?
Thank you very much for your help
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jun 29 2000 - 00:00:00 CDT