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.

I'm excited to use the new SQLAnywhere 11 full text search feature, but I haven't been able to find an answer to one question in the docs.

I can set a text index to refresh every 24 hours using 'AUTO REFRESH EVERY 24 HOURS'

So when in that 24 hour period does it refresh? Every 24 hours from when the statement is executed? 24 hours from the first refresh? midnight?

Or am I stuck with a manual index and events firing refreshes?

It would be nice if I could control when that processing is going to occur (say, after the incoming data has finished processing for the night).

asked 18 Jun '10, 08:11

Jen's gravatar image

accept rate: 0%

An AUTO REFRESH text index will be refreshed for the first time within a minute or so after being created, and then every time the interval specified in the EVERY clause passes.

Note that an AUTO REFRESH text index may be automatically refreshed before the specified interval elapses if the database server determines there were a lot of data changes - if the amount of data to be added to the index exceeds 20% of the currently indexed data, or over 50% of the indexed data is deleted.

So there is no way to guarantee the time when the text index will be refreshed using AUTO REFRESH, unless you are sure that the volume of changes is not too high.

permanent link

answered 18 Jun '10, 14:53

Elmi%20Eflov's gravatar image

Elmi Eflov
accept rate: 36%

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: 18 Jun '10, 08:11

question was seen: 2,127 times

last updated: 18 Jun '10, 14:53