The solution is to use SQL views, materialized views, ... For example, if the select statement joins multiple tables, the view likely won’t perform optimally. On the flip side, ...

Full SQL text match—In this method, the SQL text of the query's select statement clause is compared to the SQL text of the select clause in the materialized view’s defining query.

The query engine enables developers to combine precise SQL syntax with flexible natural language expressions. ... Unlike traditional materialized views that require periodic refreshes, ...