Or better yet.
Can anyone explain the use of indexing, effecting the performance of select
query, using INDEXED columns, and non indexed columns.
I.E.
Select from table where column1 = 'xxxx' and column2 = 'xxxxx'
WHERE COLUMN1 is indexed, and COLUMN2 isnt.
Well, if PG chooses to use an index on column1 alone, it will use the index to find column1='xxxx' and then check all those rows to find column2='xxxx'.
Of course, it might decide to just scan the whole table if it thinks going to the index and then the table is more expensive.
EXPLAIN ANALYSE SELECT ... will show the full details of what it is doing.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
