Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1782

DMS Tables Re-Indexing and Analysis

    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. DuplicateIndexes.csv
          0.2 kB
          Rushikesh Dattatray Bane
        2. ReviewTables_Indexing.csv
          17 kB
          Rushikesh Dattatray Bane
        3. Tables_With_Indexes.csv
          7 kB
          Rushikesh Dattatray Bane
        4. Tables_Without_PK.csv
          0.3 kB
          Rushikesh Dattatray Bane
        5. DMS Tables For Indexing.xlsx
          26 kB
          Rohan J Khandave

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) logged work - 20/Aug/19 12:22 AM
          • Time Spent:
            3h
             

            Indexes analysis
            Script creation

          rushikesh.bane Rushikesh Dattatray Bane (Inactive) created issue -
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Field Original Value New Value
          Status To Do [ 10000 ] In Progress [ 3 ]
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Attachment DuplicateIndexes.csv [ 116885 ]
          Attachment ReviewTables_Indexing.csv [ 116886 ]
          Attachment Tables_With_Indexes.csv [ 116887 ]
          Attachment Tables_Without_PK.csv [ 116888 ]
          Hide
          Permalink
          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  
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Assignee Rushikesh Dattatray Bane [ rushikesh.bane ] Samir [ samir ]
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 195961 [ 195961 ]
          samir Samir made changes -
          Fix Version/s DMS Architecture [ 10512 ]
          rohan.khandave Rohan J Khandave (Inactive) made changes -
          Attachment DMS Tables For Indexing.xlsx [ 117942 ]
          Hide
          Permalink
          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
          Permalink
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) logged work - 29/Aug/19 01:58 AM
          • Time Spent:
            1h
             

            call and discussion

          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Time Spent 3h [ 10800 ] 4h [ 14400 ]
          Worklog Id 197717 [ 197717 ]
          Transition Time In Source Status Execution Times
          Rushikesh Dattatray Bane (Inactive) made transition -
          To Do In Progress
          		8s 1

            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