Обсуждение: : Postgres IX
Can someone please explain to me , the use of
<snip>
CONSTRAINT ix_tablename
</snip>
Kind Regards,
Shaun Clements
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.
Thanks in advance
Shaun Clements
Shaun Clements wrote: > 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