Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GROUP BY disables indexes and parallel query
In the select clause, the second example has count(*). This does a full table scan. No index is available or specified. Try count(col_id), where col_id is an indexed column.
-- RobtReceived on Wed Apr 16 1997 - 00:00:00 CDT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....
Robert Miller Oracle DBA robt.miller_at_airmail.net (214) 532.6558
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....
Any opinions expressed are my own and do not necessarily represent any employer.