I need to use partial indexes
are they implemented in versions 6.3.2 / 6.5.1 ?
if they are, what's the syntax
example:
table:
grp ... name
A ... john
A ... george
B ... susan
B ... mary
how to create partial index to have seperately indexed groups A and B eg grp='B'
===
what it should be good for ?
I have large table wich is usualy beeng looked up by simple groups. So I need to save resources having the groups "pre-selected". And, however, sometimes beeing able to lookup the whole table.
dan