Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Update Indexis

Author  Topic 

vesben
Starting Member

7 Posts

Posted - 2013-10-11 : 15:44:09
What happened with indexes when some records in table are
deleted. Are they automatically updated or I must do
any commands? The database is on ACCESS.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-10-11 : 15:48:37
Indexes are maintained by the database engine. You do not need to do anything to keep them up to date.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

vesben
Starting Member

7 Posts

Posted - 2013-10-14 : 14:58:46
Thank You,

quote:
Originally posted by tkizer

Indexes are maintained by the database engine. You do not need to do anything to keep them up to date.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Go to Top of Page
   

- Advertisement -