Re: Analyzing EXPLAIN output

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Jun 1999 11:51:32 +0100
Message-ID: <930740868.17471.0.nnrp-13.9e984b29@news.demon.co.uk>

SEARCH_COLUMNS in the plan table exists for this reason, but has never been implemented.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

michael_bialik_at_my-deja.com wrote in message <7l10cc$hj3$1_at_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.
Received on Wed Jun 30 1999 - 05:51:32 CDT