Re: select max

Hi:

The MAX() function works just like any other aggregate function: it depends on the WHERE clause, GROUP BY, etc., in the rest of the SQL statement. Use EXPLAIN PLAN to see what it's actually doing.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Marco Toccafondi wrote in message <7nrt54$g8k$1_at_fe1.cs.interbusiness.it>...
>Hi,
>does anybody know about the select max performance? How it works? It just
>fetch all the records or use index? With how many records it's better not
to
>use it? (We're using Oracle 8i..).
>
>thanks ...
>andrea
>
>
Received on Fri Jul 30 1999 - 09:46:34 CDT