SQL Apprentice Question
I am learning SQL Server and I would like to ask you a question. Could
you tell me please if sequence of columns in a table has influence on
performance?
Thank you very much
Celko Answers
>> Could you tell me please if sequence of columns in a table has influence on performance? <<
Not enough to worry about in SQL Server; in DB2, it is a good idea to
put varying length coloumns toward the end of the row, however. Know
your product and be aware of the Standards and the rest of the world so
you do not think that your current dialect is a "law of Nature".
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment