it was a limitation of the DBTOOLS table manager... I am indexing right now
using alter table...
-----Original Message-----
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Friday, August 16, 2002 1:08 PM
To: Mary Stickney
Cc: Jocelyn Fournier; Mark Matthews; mysql@stripped
Subject: Re: MySQL vs. Oracle (not speed)
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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.