no I am using myisam it was just a limitation of DBTOOLS....
I am getting it done using alter table.... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Friday, August 16, 2002 1:06 PM To: Mary Stickney Cc: [EMAIL PROTECTED] Subject: Re: MySQL vs. Oracle (not speed) Mary: You can index fields containing NULL values in MyISAM tables, but not ISAM tables. If you're using ISAM tables, this might explain your performance issues. There are also other more featured table types, but MyISAM is probably going to yield the most performance in your application. Van -- ================================================================= Linux rocks!!! http://www.dedserius.com/ ================================================================= Mary Stickney wrote: > > looks to me like I can only make indexes on fields that are not null... > this one is not , not null > > -----Original Message----- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 11:34 AM > To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED] > Subject: Re: MySQL vs. Oracle (not speed) > > Hi, > > I see you do an order by on AdminHierarchy.WritingAgentSlot but this column > is not indexed. > Please tell me if an index on this column improve the speed of the query a > bit. > > Regards, > Jocelyn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
