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 = '' and column2 = 'x'
WHERE COLUMN1 is indexed, and COLUMN2 isnt.
Well, if PG c
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 = '' and column2 =
'x'
WHERE COLUMN1 is
Title: : [GENERAL] Postgres IX
Can someone please explain to me , the use of
CONSTRAINT ix_tablename
Kind Regards,
Shaun Clements
