Re: using multiple columns Index

2021-12-16 Thread Chrystophe Vergnaud
Hi Maxim, Thanks for the details. But do you have a tweak in mind to get better response time on this kind of request ? BR, Chrystophe Vergnaud Architect @ Cyblex Technologies Le jeu. 16 déc. 2021 à 15:09, Maksim Timonin a écrit : > Hi, Chrystophe! > > Multifield index should

Re: using multiple columns Index

2021-12-16 Thread Chrystophe Vergnaud
Hello Stephen, I was created with SQL : CREATE INDEX IF NOT EXISTS "t_idx_1" ON MYSCHEMA."t" ("a", "b", "c"); BR, Chrystophe Vergnaud Architect @ Cyblex Technologies Le jeu. 16 déc. 2021 à 13:51, Stephen Darlington < stephen.darling.

using multiple columns Index

2021-12-16 Thread Chrystophe Vergnaud
s in advance for your help. Best regards, Chrystophe Vergnaud Architect @ Cyblex Technologies