Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Index question
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
![]() |
![]() |