Does anyone havea clue of how mysql optimizes empty fields and how
query speed is affected?
i have a db with around 3 million rows where i need to add 2 new fields
- one smallint and one varchar(10)
for alot of the rows they will be empty, but because of query speed i
opt to put them ion the maintable instead of a seperate table so i can
avoid slow joins.
what will be better for queryspeed/size: adding them with NULL using
NULL as default or with NOT NULL using 0 and '' as defaults?
Regards
Martin Jespersen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
