Question
· Apr 26

SQL Cached Queries understanding

Hello Community,

I'm executing the same query with same  column name but in different case. An unique cached query generated while query executed first time. The query preparser only normalize the keywords and send to the SQL engine generates the Hash. Eventually use the cached query next use.

Now my question, The hash values are same for both of the queries. Then why it creates two cached queries.

Query1: select * from MyLearn.Test where Name['Kev1'

Query2: select * from MyLearn.Test where NamE['Kev1'

Thanks!

Product version: IRIS 2023.1
$ZV: IRIS for Windows (x86-64) 2023.1 (Build 263) Wed Mar 13 2024 16:01:00 EDT
Discussion (0)1
Log in or sign up to continue