Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> link between parsing time and number of indexes on a table

link between parsing time and number of indexes on a table

From: <kerbiquet_at_hotmail.com>
Date: 2000/06/29
Message-ID: <8jfuda$hb7$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US