On Fri, Jan 25, 2002 at 04:02:23PM -0800, Bruce Sandell wrote: > > So does this mean that you should or should not bother using indexes > on a heap table?
You should use an index on a heap table column just like you would for any other table. It's just that the index isn't a B-Tree like with MyISAM tables--it's just a hash lookup. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 23 days, processed 526,177,066 queries (264/sec. avg) --------------------------------------------------------------------- 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