Question Re: Disable and enable materialized view in Technology Q&A

Disable and enable materialized view

Former Member — Tue, 07 May 2013 09:29:56 GMT

Hi all,

I'm currently playing with some of features in SQL Anywhere 16. I have various tables that I have joined together in a materialized view for the purposes of full text searching some columns from each of the tables.

In attempting to add a new column to one of the tables I discovered that not only did I have to disable, enable and refresh the view but it also dropped both my unique and text indexes.

Is this just the way it is and I will have to recreate all my indexes every time or is there something else I can do to avoid it?

Thanks

Re: Disable and enable materialized view

Former Member — Tue, 07 May 2013 10:47:56 GMT

The indexes are dropped as a consequence of disabling the view.

Re: Disable and enable materialized view

Former Member — Fri, 10 May 2013 09:11:28 GMT

So I have to disable the view in order to add the column and disabling the view removes all the indexes? There is no way around this?

I can see this being somewhat annoying.