-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Mladen Gogala
Sent: Thursday, October 23, 2003 10:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
B*tree indexes
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
why would you not need a sort with a full index scan
, October 23, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in
an analytic
function?
i cant attach the 10053 trace. it has proprietary info. There
isnt much in analytic explain plan either
, October 23, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in
an analytic
function?
i cant attach the 10053 trace. it has proprietary info. There
isnt much in analytic explain plan either.
does anyone
over an index fast full scan in an analytic function?
The FF index scan reads all the block in the index, using multiblock
reads. The kernel then discards the branch blocks. If sorting of the
result set is required, then this is a separate row source operation,
because the rows don't come out
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: index full scan over an index fast full scan in an
analytic function?
The FF index scan reads all the block in the index, using multiblock
reads. The kernel then discards the branch blocks. If sorting of the
result set is required
Tanel
Tanel Poder wrote:
As an addition to Vladimir's response:
I cannot provide you with detailed information -- can only give pointers
to the documentation -- otherwise it would look suspicious :)
Full scan will search from index root block using branch blocks to first
leaf block. And since all
Vladimir Begun wrote:
Tanel Poder wrote:
FFS will scan from index header block (note that index segment header and
index root block are different ones) up to segment high water mark using
multiblock reads and ignoring contents of root, branch, bitmap, extent
map,
freelist group blocks. Rows are
I have an index on the two columns used in this query. Why would the optimizer choose
an index full scan over an index fast full scan?
My question isnt why an index is used, but the type of index scan?
select *
from (select col1, col2,
dense_rank()
over (partition by
[EMAIL PROTECTED]
Subject: index full scan over an index fast full scan in an analytic function?
I have an index on the two columns used in this query. Why would the optimizer
choose an index full scan over an index fast full scan?
My question isnt why an index is used, but the type
of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
i cant attach the 10053 trace. it has proprietary info. There
isnt much in analytic explain plan either.
does anyone know in general why a full scan would be faster than
a fast full scan
Thu PM 03:09:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: index full scan over an index fast full scan in an
analytic function?
I have an index on the two columns used in this query. Why
would the optimizer choose an index full scan over an index fast
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
why would you not need a sort with a full index scan and need one with a
fast
: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an analytic
function?
why would you not need a sort with a full index scan and need one with a
fast full scan?
- Original Message -
To: Multiple
.
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Ryan
Sent: Thursday, October 23, 2003 9:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: index full scan over an index fast full scan in an
analytic
function?
why
Vladimir Begun wrote:
Full scan
This is available if a predicate references one of the columns in the
index. The predicate does not need to be an index driver. Full scan
is also available when there is no predicate, if all of the columns
in the table referenced in the query are included in the
16 matches
Mail list logo