MySQL Forums
Forum List  »  Memory Storage Engine

type of index on memory tables
Posted by: Alexander
Date: December 17, 2006 06:50PM

This topic is duplicate from Newbie forum. I think it would be more help here.

I use mysql 5.0.18.

I need some advice in what type of index to prefer when using MEMORY tables - BTREE or HASH?
I want to put in memory several tables with number of rows from 100 throuh 20000 in each. Not a lot I guess.

My memory tables contain a kind of categorized vocabulary with common table structure like this:
create table
id int,
name CHAR(200),
primary key (id),
{key | unique key} `name` (name)

There can be duplicates in some columns but I feel it would not be many of them.

Is it possible to gain meaningful time profit from choosing one index type and not the other when selecting from such tables? (selects may contain many joins with these tables)

Thanks for your help.

Options: ReplyQuote

Written By
type of index on memory tables
December 17, 2006 06:50PM
December 18, 2006 09:52AM

Sorry, you can't reply to this topic. It has been closed.

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.