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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-26 : 14:34:21
|
Mathieu writes "With many tables in my databases, there are some indexes attached to tables. The problem is that i never designed those indexes. The problem is that i just can't drop those index. The indexes all begin with '_WA_Sys_'. I just can't find any infos on this. I suppose that those indexes are duplicating the physical size of my database. So, the question is clear...
What are those indexes,
where they come from,
what's there use,
how can i get rid of them without recreating the table?
System(win2000,sql7.0 & sql2000)
Thanks
Mathieu" |
|
|
|
|
|
system indexes