hi friends,

I ran the check integrity maintenance job last Saturday and it took exactly 10 hours to run successfully and there were absolutely no errors logged in the log file....

thank you grant , my bad i was missing the 'defrag' keyword in my search ..

below is the link i used

http://lmgtfy.com/?q=Michelle+Ufford%27s+scripts+for+maintaining+your+indexes

hi grant, could you share the link please?

Hey friends,

Thanks for your valuable suggestions. highly appreciated.

@grant:

I will be running the check Integrity job only once on Sunday at 12PM, i hope it doesn't run too long because...

Does the DB have to be offline when in rebuild indexes on this table? This a 300GB fact table , what will happen if any application issues a select statement...

many thanks

Okay I was being impatient , I must have taken your experts words. It took around 75 minutes but its over now. Thank god.

Hello,

Thanks for your response, yes apologies 'I meant Index Physical Statistics report . I have been waiting over 45 minutes now. Do you think the report is going...