So does this mean that you should or should not bother using indexes on a heap table?
Thank you very much for you help on this matter. Bruce -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 3:48 PM To: Bruce Sandell Cc: [EMAIL PROTECTED] Subject: Re: Indexing hash tables On Fri, Jan 25, 2002 at 03:44:07PM -0800, Bruce Sandell wrote: > > Is the index for a hash table stored on disk or in memory? You mean for HEAP tables, which used hashed indexes? > I have a hash table that I am constantly adding data to, which means > the index is constantly being updated. If I keep the size of the > key buffer sufficiently large, will the new index values be there > upon creation, or not until they are read from disk? I would like > to avoid having to read from the disk for every query that uses an > index. HEAP tables don't use MySQL's key buffer for anything. There's no extra data to store. If MySQL needs to find out if a value is there, it simply hashes the value and checks for the hashed value. 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 525,472,042 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 --------------------------------------------------------------------- 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