indexes on multiple columns
От | Lewis Bergman |
---|---|
Тема | indexes on multiple columns |
Дата | |
Msg-id | 200202222059.g1MKx2826151@lewis.abi.tconline.net обсуждение исходный текст |
Ответы |
Re: indexes on multiple columns
|
Список | pgsql-novice |
I have read the manual on indexes but i am still in the dark as to how to construct these indexes so that I can use the fewest indexes but still have my query make use of them. An example follows. A table, item, has these columns among others: id serial pk name varchar description text automated boolean available boolean class varchar fk subclass varchar fk Most of the time searches will take place soley based on the id: SELECT id FROM item WHERE id='123456'; But on occasion I might want to see info relating to a specific item and its availability: SELECT id FROM item WHERE name='access' AND available='true'; or just SELECT id FROM item WHERE available='true'; If I make an index on both the name and available columns, will both the second and third query use it? -- Lewis Bergman Texas Communications 4309 Maple St. Abilene, TX 79602-8044 915-695-6962 ext 115
В списке pgsql-novice по дате отправления: