On Tue, May 5, 2009 at 2:06 PM, Matt Jarvis <[email protected]> wrote: > When a query is run against a table, are the records, by default, > returned in natural order? ------------------------------------------
All responses so far are incorrect. SQL Server answer below. Your natural order is a function of the index that teh server used. Was that index the clustered primary key, or was it an fkey to another table for lookup values? You can SEE what it index was used if you go to the execution plan for that query. Yes you have to dig down into it but heck that is crack for data fiends anyway. :) -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
