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 -> Re: using indexes

Re: using indexes

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 7 Dec 2000 17:33:26 -0600
Message-ID: <90p6o6$6sk$1@garnet.tc.umn.edu>

You can have the engine optimize the search path but if there is no index defined or there are badly designed indexes for the engine to use the results will be slow.

So sometimes it is good to look at the defined indexes.

I have a script called index_check at www.sofbot.com which takes a look at the cardinality issues.

-- 

---------------------------------------------------------
Steven Hauser email: hause011@tc.umn.edu URL: http://www.sofbot.com/
---------------------------------------------------------
Received on Thu Dec 07 2000 - 17:33:26 CST

Original text of this message

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