Re: Index question

[Tanel Poder]

Hi!   If you are new to Oracle, it might be easier to use DBA studio (which usually comes with Oracle) or other GUI tool such is Toad (http://www.toadsoft.com/).   But if you want to learn how things really work, then open up sqlplus and start experimenting with data dictionary views:   select table_name, index_name, column_name, column_position from user_ind_columns where table_name = '<your_table_name>' order by 1, 3, 4   Note that your table name will likely be upper case even though you created it with lower case name. The column_position column shows you in which order are the columns in composite indexes.   Tanel. ----- Original Message ----- From: Teresita Castro To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 25, 2003 2:44 AM Subject: 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:   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.