Re: Index question

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 <A href="http://www.toadsoft.com/">(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_columnswhere 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.
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">Teresita Castro To: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">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:
   
  <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 - 19:28:28 CDT