From: Dan Nelson
Date: August 16 2002 6:08pm
Subject: Re: MySQL vs. Oracle (not speed)
List-Archive: http://lists.mysql.com/mysql/117381
Message-Id: <20020816180804.GB74231@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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