Please help with indexes

[Marcin Lewandowski]

Hi,
i have table which would contain data describing holiday houses. It's it:
id        bigint(20) unsigned     PRI    auto_increment
name        tinytext
description    text
webpage        tinytext
email        tinytext
whole_can    tinyint(1) unsigned
whole_only    tinyint(1) unsigned
type    enum('house','apartment','hotel')
person_min    tinyint(3) unsigned
person_max    tinyint(3) unsigned
children_min    tinyint(3) unsigned
children_max    tinyint(3) unsigned
animal_min    tinyint(3) unsigned
animal_max    tinyint(3) unsigned
icons    bigint(20) unsigned
date_add    datetime
date_modify    datetime
I will make a search which should find using random criteria. Sometimes 
it would be "find houses (type=house) which can contain 4 to 5 person 
(person_min >= 4 and person_max <= 5)", sometimes it would be "find 
hotels which could be reserved whole (type=hotel and whole_can=1) and 
which could contain 100 person (person_min >= 100 and person_max >= 100)"

They could be more types of queries, but mostly which person_min/max and 
 type columns.

How I should create indexes to boost SELECT queries? My tables are innodb.
--
Marcin Lewandowski
[  mailto:[EMAIL PROTECTED]  gg:188068 jid:[EMAIL PROTECTED]  ]
[   http://www.nosoftwarepatents.com/pl/m/intro/index.html   ]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]