Igor, Sony, Naveen,
Thanks all for your kind help.
Regards,
Waseem.
--
On Thu, 06 Feb 2003 17:43:40
Sony kristanto wrote:
>Hi Waseem,
>
>When you decide to use 'group by' in your query, I can just suggest you to
>not use 'order by' clause, my reason is, it will makes your query running
>slow. Try to just use 'group by' clause without 'order by' clause, your
>query will running faster than when you include 'order by' clause. Have a
>nice day.
>
>Rgrds,
>
>Sony
>
>> -----Original Message-----
>> From: waseem khan [SMTP:[EMAIL PROTECTED]]
>> Sent: Thursday, February 06, 2003 10:40 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Re: SQL
>>
>> Lots of emails were sent yesterday, so in case if any kind soul had missed
>> my request (which didn't bear any result), I am posting this again. Please
>> help if you can.
>>
>> Thanks.
>> --
>>
>> On Wed, 05 Feb 2003 09:59:29
>> waseem khan wrote:
>> >Folks,
>> >
>> >Is there a much better way of writing the following SQL statement,
>> bearing in mind the performace hits due to the use of functions in the
>> GROUP BY and ORDER BY clauses?
>> >
>> >SELECT TO_CHAR(TEST_DATE, 'MON RRRR') XXX, count(*)
>> >FROM TBL_XYZ
>> >WHERE TEST_VAL = DECODE(:P_VALUE, 'BEGIN', 'B', 'END', 'E')
>> >AND TEST_DATE BETWEEN :P_START_DATE AND :P_END_DATE
>> >GROUP BY TO_CHAR(TEST_DATE, 'MON RRRR')
>> >ORDER BY TO_DATE('01 '||XXX);
>> >
>> >Thanks.
>> >
>> >
>> >
>> >_____________________________________________________________
>> >Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
>> >http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> >--
>> >Author: waseem khan
>> > INET: [EMAIL PROTECTED]
>> >
>> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> >San Diego, California -- Mailing list and web hosting services
>> >---------------------------------------------------------------------
>> >To REMOVE yourself from this mailing list, send an E-Mail message
>> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> >the message BODY, include a line containing: UNSUB ORACLE-L
>> >(or the name of mailing list you want to be removed from). You may
>> >also send the HELP command for other information (like subscribing).
>> >
>> >
>>
>>
>> _____________________________________________________________
>> Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
>> http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: waseem khan
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Sony kristanto
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: waseem khan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
