Re: : [GENERAL] Postgres IX

[Shaun Clements]

Title: : [GENERAL] Postgres IX

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

 

Kind Regards,
Shaun Clements