2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
Hi stanleyhunju,
There is no defined or specific list of conditions for similar queries. In your example, query 3 is considered similar to query 1 since they are searching for the same results or dataset but in a slightly different way. If you first execute query 1 and then query 3, query 3 in this case will use the result cache.
I usually use the system view SVL_COMPILE to analyze the compilation phase of queries.
Regards, Ziad
1
Redshift query engine can rewrite the queries before execution. It will see that query 3 is similar
to query 1 and can be rewritten to match it. Thus it can still leverage the compile cache for query 3.
répondu il y a 7 mois
Contenus pertinents
- demandé il y a 5 mois
- demandé il y a un an
- demandé il y a un an
- demandé il y a 6 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
Ah, I got it, thanks a lot @MilindOke