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

asked 07 May '13, 09:29

Simon's gravatar image

Simon
96449
accept rate: 100%


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

permanent link

answered 07 May '13, 10:47

Elmi%20Eflov's gravatar image

Elmi Eflov
7811014
accept rate: 31%

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.

(10 May '13, 09:11) Simon
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×197
×15

question asked: 07 May '13, 09:29

question was seen: 790 times

last updated: 10 May '13, 09:11