RE: SQL

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:waseem.khan_at_lycos.com]

>> 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: waseem.khan_at_lycos.com

>> >

>> >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: ListGuru_at_fatcity.com (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: waseem.khan_at_lycos.com

>> 

>> 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: ListGuru_at_fatcity.com (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: Sony_at_polyfincanggih.com

>

>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: ListGuru_at_fatcity.com (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: waseem.khan_at_lycos.com

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: ListGuru_at_fatcity.com (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).