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.
Subject
Views
Written By
Posted
type of index on memory tables
8024
December 17, 2006 06:50PM
3772
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.