SQL order by question

[Gary Lehman <Gary_Lehman@xxxxxxxxxxxxxx>]

Hello all you SQL gurus,

I use SQL quite a bit, but never really got down to the intricate question
of what really works more efficiently.  My question is(may sound simple), if
you do a DECLARE CURSOR on a logical that is in say SSN, DATE, PRODUCT order
and then do a order by SSN, DATE, PRODUCT order does that cause it to do
more work to create an extra index??  If the logical is already in that
order is it detrimental to do an order by with the same fields?  I probably
already know the answer to this, but I wanted to double check.

Also do you specify a FETCH ONLY on a DECLARE CURSOR if you're not doing any
updating and you want the time it takes to build the table to be less?? 

Gary Lehman
Programmer Analyst II
Missouri Consolidated Health Care Plan

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---