Suppose I have a table with some fixed length fields and some variable length fields, and the variable length fields may be null or very long. Does the order of the fields in the table matter? Can I save space by putting all the fixed length fields at the "top" of the column list?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does column order matter for efficient disk usage?
- Thread starter Sheco
- Start date
Similar threads
- Locked
- Question
- Locked
- Question