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
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
SELECT id FROM item WHERE name='access' AND available='true';
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?
4309 Maple St.
Abilene, TX 79602-8044
915-695-6962 ext 115
pgsql-novice by date
|Next:||From: john-paul delaney||Date: 2002-02-22 21:11:42|
|Subject: Re: Nu-B\Column:Alter type|
|Previous:||From: john-paul delaney||Date: 2002-02-22 19:43:35|
|Subject: Re: Nu-B\psql:Command Recall,Repeat?|