Slater, Chad wrote:
Does the ordering of columns in a table have any impact on performance?
Chad,
Not significantly if your rows have less than a couple of hundred bytes of data. If they are larger than that they will spill into overflow page(s). It takes longer to insert and select data from the columns that are on the overflow page(s). If you have wide rows (i.e. rows with long string fields or blobs) you should try to locate those after all the smaller fields. In particular, id fields and fields used for joins should be placed at the beginning of the row to ensure they are not located on overflow pages.
HTH Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
