Disable and enable materialized view

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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.