From: | Lewis Bergman <lbergman(at)abi(dot)tconline(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | indexes on multiple columns |
Date: | 2002-02-22 20:59:02 |
Message-ID: | 200202222059.g1MKx2826151@lewis.abi.tconline.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | john-paul delaney | 2002-02-22 21:11:42 | Re: Nu-B\Column:Alter type |
Previous Message | john-paul delaney | 2002-02-22 19:43:35 | Re: Nu-B\psql:Command Recall,Repeat? |