RE: Embedded SQL: ORDER BY

Phil,

I think it really depends on what existing indices you have built. If you
already have an index by field1, field2, then you're better off explicitly
ordering the SQL to match the index.  I don't believe the query optimizer
will normally "imply" a key from the where clause.

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Phil [mailto:sublime78ska@yahoo.com]
Sent: Friday, October 12, 2001 6:00 PM
To: rpg400-l@midrange.com
Subject: Embedded SQL: ORDER BY


All,

If I do this:

        select * from file where field1 = '01'

and I want to use the order by clause:

        order by field1, field2

should I include 'field1' on the order by clause or is it unnecessary since
I'm selecting 'field1 = 01'?  Or does omitting it cause a performance
problem?

Thanks,

Phil


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.