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

Home -> Community -> Mailing Lists -> Oracle-L -> Index question

Index question

From: Teresita Castro <Teresita.Castro_at_s-martmx.com>
Date: Tue, 24 Jun 2003 16:06:06 -0700
Message-ID: <F001.005B8C42.20030624154441@fatcity.com>

Hi!
I am new using Oracle, and what to ask some doubt about indexes
 

How can I see how many fields of a table have indexes?
 

I am trying to do an update but is too slow, so what I am trying to find is the way to uses an index that can help to do this update  more quickly.
This is the query example:
 

<FONT color=#000080
size=2>Update ITEMLOC
SET
AVERAGE_COST=5.5
WHERE
ITEM='0010096'
 

I will like to find the way to set and index that have the item filed include to do this update quicker. Right now it takes like 30 seconds per item and we have to update like 9,000 items.
 
Received on Tue Jun 24 2003 - 18:06:06 CDT

Original text of this message

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