It seems that someone got bitten very hard in a soft area by a Null one
day.
On a more practical level, Oracle recommended to design the table with
the field where NULLs are to be expected at the end of the table, that
saves a little space and two, as the use of indexes is invalidated in
case of nulls its is better to place the important indexed fields toward
the beginning of the table.
michel
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 090313-0, 03/13/2009
Tested on: 3/14/2009 10:23:29 AM
avast! - copyright (c) 1988-2009 ALWIL Software.
http://www.avast.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
