Materialized view in ASA-9

[former_SQLA_member1694872]

Hi,

How to create a materialized view in ASA-9?

[VolkerBarth]

...wasn't that already answered (and now deleted) on that other question🙂

[former_SQLA_member1694872]

Sorry, Volker Barth, I thought you had suggested creating new question.

[VolkerBarth]

Yes, it's alright, please note the ":)" in my comment above...

[Breck_Carter · Accepted solution]

You cannot. Materialized views were introduced in SQL Anywhere 10.

FYI SQL Anywhere 12 is the most current version, and version 16 is coming soon (skipping numbers 13, 14 and 15).

[VolkerBarth · Accepted solution]

FWIW, with older versions, one can surely "mimic" materialized views by using base tables (possibly global temporary ones) and "re-fill them" automatically (on demand or on a scheduled basis) and revoke users rights to modify the contents directly. - Apparently, that cannot help for "view matching" (i.e. the automatic usage of such views in queries without directly referencing them) - but that advanced feature may not the required in many cases.

Note, that immediate views (i.e. automatically freshened ones) have been introduced in v11.