Re: Help query

On Thu, 27 Mar 2008 22:09:35 +0100, "astalavista" <nobody_at_nowhere.com> wrote:

>Hi,
>
>Is there a way to speedup this query ?
>(XIF705PF_REVISIONHISTORY is an index on transactionid )
>Thanks for your help ...
>(10.2.0.3)
>SELECT MAX (transactionid) AS lasttrialtransaction,
>
>COUNT (DISTINCT transactionid) AS transactioncount
>
>FROM pf_revisionhistory
>
>WHERE transactionid IS NOT NULL
>
>
>
>SELECT STATEMENT Optimizer Mode=ALL_ROWS 1 8740
> SORT GROUP BY 1 6
> INDEX FAST FULL SCAN PERFORMPALIER5UID.XIF705PF_REVISIONHISTORY 16 M 91
>M 8740
>
>

Apparently it is already using the index. There is an index being used, there is only one column in the select list, so this must be the anonymous index you refer to.

-- 
Sybrand Bakker
Senior Oracle DBA