"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.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
