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?
asked 07 May '13, 09:29
The indexes are dropped as a consequence of disabling the view.
answered 07 May '13, 10:47