Ask the Expert

How does view index building work?

How does View Index rebuilding work? If a database(which resides on a server) is opened from different clients, will the view index be rebuild on each client?
It depends on how the view index is setup in the DB. Usually, they are set to not be discarded. If that is the case, then once a view is indexed, it will remain indexed. After that, incremental indexes are performed by subsequent client accesses for the new/modified documents. This is usually not even noticeable in terms of performance.

This was first published in November 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: