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 -> Analyzing EXPLAIN output

Analyzing EXPLAIN output

From: <michael_bialik_at_my-deja.com>
Date: Fri, 25 Jun 1999 22:38:05 GMT
Message-ID: <7l10cc$hj3$1@nnrp1.deja.com>


Hi.

Is there a way to get a number of index columns used for RANGE_SCAN ? ( 1 out of n, 2 out of n, etc. ).
There is such info for DB2 ( matching_columns ), but I didn't find anything in Oracle documentation.

Michael.



Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 17:38:05 CDT

Original text of this message

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