Details

    • Type: Research
    • Status: In Progress
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: DMS Architecture
    • Labels:
      None
    • Company:
      All Clients/Multiple Clients

      Description

      DMS Tables Re-Indexing script creation and Analysis of missing indexes.

       

      CC Samir Rohan J Khandave

        Attachments

        1. DMS Tables For Indexing.xlsx
          26 kB
        2. DuplicateIndexes.csv
          0.2 kB
        3. ReviewTables_Indexing.csv
          17 kB
        4. Tables_With_Indexes.csv
          7 kB
        5. Tables_Without_PK.csv
          0.3 kB

          Activity

          Hide
          rushikesh.bane 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
           

          Show
          rushikesh.bane 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  
          Hide
          rohan.khandave 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

          Show
          rohan.khandave 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

            People

            Assignee:
            samir Samir
            Reporter:
            rushikesh.bane Rushikesh Dattatray Bane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h
                4h