I reviewed all the indexes and pulled out stats for same.
Script for Re-Indexing is done. I have tested it on a local server.
There are tables on which we need to review the columns and necessary indexes which needs to be identified by the DEV team.
I have attached sheets for review. Please go through these for a clear of a picture of needed indexes.
Rushikesh Dattatray Bane (Inactive)
added a comment - Hi Samir Samir.Shaikh@careerbuilder.com ,
I reviewed all the indexes and pulled out stats for same.
Script for Re-Indexing is done. I have tested it on a local server.
There are tables on which we need to review the columns and necessary indexes which needs to be identified by the DEV team.
I have attached sheets for review. Please go through these for a clear of a picture of needed indexes.
Review Sheet: ReviewTables_Indexing.csv
Regards,
Rushikesh
Rohan J Khandave (Inactive)
added a comment -
As per discussion in call , created excel. All CSV files are added in excel along with tables identification done in call.
DMS Tables For Indexing.xlsx
CC – Samir , Rushikesh Dattatray Bane
Hi Samir Samir.Shaikh@careerbuilder.com
,

I reviewed all the indexes and pulled out stats for same.
Script for Re-Indexing is done. I have tested it on a local server.
There are tables on which we need to review the columns and necessary indexes which needs to be identified by the DEV team.
I have attached sheets for review. Please go through these for a clear of a picture of needed indexes.
Review Sheet: ReviewTables_Indexing.csv
Regards,
Rushikesh