July 2, 2003 at 9:21 am
I have created my own reorg process to reorg the tables and indexes through use of DBCC DBREINDEX and DBCC INDEXDEFRAG. However, my process will not touch system created indexes. Do I need to be cautious with these indexes? Is there anything I can even do about them? I haven't been able to find any documentation on how or why they are created.
Example
Table:AGENTS
IndexName: tAGENTS
IndexID: 255
ScanDensity: 41
LogicalFrag: 100
Thanks,
CyGradFan
July 2, 2003 at 9:30 am
I'm not sure you can or that you want to. These tables are not in general, accessed that often.
Steve Jones
July 2, 2003 at 12:10 pm
Let me clarify. These indexes are on user tables and not system tables. I have not created any of these indexes, but they seem to 'magically' appear on tables with some size to them. All of theses tables have indexes I defined on them.
July 3, 2003 at 1:12 pm
If you are talking about indexes that start with "WA_", those are auto-statistics created by the query optimizer on fields that it believes would be helpful to have stats on. They can show up as "indexes" in some places in the GUI, but they are not true indexes. You may wish to examine them for possible promotion into real indexes, based upon query activity against the table.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply