Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


How to create a materialized view in ASA-9?

asked 06 Feb '13, 07:30

Walmir%20Taques's gravatar image

Walmir Taques
accept rate: 12%

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

(06 Feb '13, 09:11) Volker Barth
Replies hidden

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

(06 Feb '13, 09:39) Walmir Taques

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

(06 Feb '13, 10:00) Volker Barth

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).

permanent link

answered 06 Feb '13, 07:58

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

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.

(07 Feb '13, 04:34) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 06 Feb '13, 07:30

question was seen: 1,871 times

last updated: 07 Feb '13, 04:35