Help query
From: astalavista <nobody_at_nowhere.com>
Date: Thu, 27 Mar 2008 22:09:35 +0100
Message-ID: <47ec0d0e$0$14005$426a74cc@news.free.fr>
Date: Thu, 27 Mar 2008 22:09:35 +0100
Message-ID: <47ec0d0e$0$14005$426a74cc@news.free.fr>
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
Received on Thu Mar 27 2008 - 16:09:35 CDT