"Dann Corbit" <[EMAIL PROTECTED]> writes: > Creating the following index had no effect on performance! > create unique index i1 on "CNX_DS2_53_SIS_STU_OPT_FEE_TB" ("RT_REC_KEY", > "cnxarraycolumn", "CRC");
What does EXPLAIN ANALYZE have to say about the query? If you set enable_seqscan = 0, does the explain result change? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster