RE: Query unable to utilize index without typecast to fixed length character

Hi, Your error is the use of quotes around the constant numeric value! You should not use it because that means then that it is a character constant causing an implicit conversion. We must consider any implicit conversion in our queries as a potential problem and we must absolutely avoid u

Re: Is there any tool which will help me run and explain analyze about 150 queries?

Just wrote up my experiences setting up auto_explain on Google Cloud SQL to get explain analyze: https://www.kylehailey.com/post/auto_explain-on-google-cloud-sql-gcp On Fri, Apr 7, 2023 at 9:40 PM Jerry Sievers wrote: > kunwar singh writes: > > > Hi Listers, > > Anyone here use such a tool