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: Q: Indexes

Re: Q: Indexes

From: Dan Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 02 Feb 1999 15:48:17 -0800
Message-ID: <36B78EC1.A31F0704@exesolutions.com> 





> Having no special experience with Oracle 8 on Windows NT, is there any


> particular possibility to check which indexes a transaction is using?





Use Explain Plan. You will find it documented in your manual. Your DBA
will have to set it up for you by running a SQL script as SYS.



Daniel A. Morgan

Received on Tue Feb 02 1999 - 17:48:17 CST












Original text of this message













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