Hi,
http://support.microsoft.com/kb/943345/. In this link, we have a stored procedure which reindexes or rebuilds the indexes of sharepoint databases.
Search database
Profile database
Content database in SQL Server 2005.
So my question is Do we need to create this stored procedure in each of these 3 databases and schedule as a weekly job? or If we create this procedure in master database, how can we use this procedure to defragment the indexes of all these 3 databases?
can we use this procedure to defragment the indexes in other databases too including the above 3 databases?
Plz advice me
Thank You
Madhu