reindexing 
Author Message
 reindexing

Hi,

Sometimes I get a message: 'index is out of date'. I solved this problem
until now by using the Database Desktop.
I have two questions:
1. How does an index become out of date?
2. Does anyone have code which identifies the problem when a table is
opened and corrects it automatically?

Thanx,
--

Vezass Amsterdam      Oostenburgervoorstraat 134  1018 MR  AMSTERDAM



Tue, 19 Oct 1999 03:00:00 GMT
 reindexing


Quote:
> 1. How does an index become out of date?

When your are updating database (table) without opened index.

Quote:
> 2. Does anyone have code which identifies the problem when a table
> is opened and corrects it automatically?

Generally it can't happen if you take care in program that database is
never updated with closed index but
for instance you can check file date/time stamp for database and index file
to assure they are the same.

--
Jovan Bulajic
Belgrade, Yugoslavia



Wed, 20 Oct 1999 03:00:00 GMT
 reindexing

|>Hi,
|>
|>Sometimes I get a message: 'index is out of date'. I solved this problem
|>until now by using the Database Desktop.
|>I have two questions:
|>1. How does an index become out of date?
|>2. Does anyone have code which identifies the problem when a table is
|>opened and corrects it automatically?
|>
|>Thanx,
An index will get out of date, if in your code you have appended a record,
edit a record, or delete a record without having the index open.  You must
ensure the current is open before modifying the database.



Thu, 21 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ReIndexing table

2. Reindexing Issues

3. Reindexing

4. ReIndexing/Recompiling Help

5. Automating Full Text Catalog ReIndexing From Stored Procedure on Another Database

6. Embedding DBCC Checkdb in reindexing statement

7. Reindexing Error

8. Reindexing Stored Procedures

9. Reindexing large database

10. Reindexing a database

11. Table Reindexing

12. 6.5 table reindexing


 
Powered by phpBB® Forum Software