I was looking for tables with no indexes, and I keep
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !_WA_Sys_...." are SQL Server statstics. You have AUTO Stats turned on.
This is expected. You should leave them alone.
"Jim Trowbridge" <jtrowbridge@.adelaidebank.com.au> wrote in message
news:07be01c36600$78857070$a401280a@.phx.gbl...
I was looking for tables with no indexes, and I keep
finding entries in sysindexes with names
like "_WA_Sys_....", which I certainly don't create.
The last one is possibly attached to a column defined as
nvarchar(128), but its the only column in the table
defined that way, and the other columns don't have such an
index ! very confusing.
Does anyone know what these are ?
Does anyone have an SQL script that will correctly!
identify tables without indexes ? This would be hugely
appreciated !
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment