On 2/15/23 02:46, Laurenz Albe wrote: [snip]
Which one is best?CREATE UNIQUE INDEX ix1 ON art (code, etb) or CREATE UNIQUE INDEX ix1 ON art (etb, code)(or its PRIMARY KEY equivalent)Both are the same. There is an old myth that says that you should use the moew selective column first (which would be "code"), but that is just a myth.
Only on Postgresql? -- Born in Arizona, moved to Babylonia.
