| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Dan Nelson | Date: | August 16 2002 6:08pm |
| Subject: | Re: MySQL vs. Oracle (not speed) | ||
| View as plain text | |||
In the last episode (Aug 16), Mary Stickney said: > looks to me like I can only make indexes on fields that are not > null... this one is not , not null Indexing of NULL columns went into Mysql 3.23.2 (Dec 16, 2000). With tables this large, you might also want to raise some of the cache parameters in my.cnf . http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html -- Dan Nelson dnelson@stripped
