November 23, 2005 at 11:17 pm
Hi,
How can i know
(1) index create date
(2) index drop date
(3) how often reindexing is done.
thanx
from
Killer
November 28, 2005 at 8:00 am
This was removed by the editor as SPAM
November 29, 2005 at 3:47 pm
1) No. There is not any data information in the sysindexes table.
2) No.
3) There may be a DBCC command but I am not sure.
However in SQL 2005 DDL triggers will supply the means for an answer for #1 & #2.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 29, 2005 at 10:17 pm
Thanxs for ur reply.
The same answer i got from microsoft support.
I needed this information becauses the company i am working was asking me that he want a report to see that reindexing is being done or not.
As i believed that the navison administrator had not scheduled the reindexing and reindexing was not done from more then a year and that leads to slow application performance.
from
Killer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply