RE: MySQL vs. Oracle (not speed)

[Mary Stickney]

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