"D. Stimits" <[EMAIL PROTECTED]> writes:
I'm not looking for an exact answer here, but instead something more "rule of thumb". If I have a table with many fields, and I retrieving small groups of fields during a SELECT, whereby the groups of fields are indexed and/or clustered, will I get a faster select in the left-most fields, or the right-most fields? Or will it not matter?
Fields earlier in the table definition (further to the left) are marginally faster to access than ones further to the right. I doubt it would be real noticeable unless you had hundreds of fields altogether.
Do we still "cache" field offsets for not-nullable-fixed-size columns?
Jan
--
#======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
