Posted by --CELKO-- on 07/06/06 23:00

>> 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".

• Next in forum: Re: Odd SQL IN usage?
• Prev in forum: Re: Create trigger - do users need to be out?
• Thread view: Re: sequence of columns and preformance

[Reply to this message]