none
Indexes???

    Question

  • --New 
    ALTER TABLE dbo.EventTracking
    ADD CONSTRAINT XPKtblEventTracking PRIMARY KEY CLUSTERED ([Object_ID]);
    CREATE UNIQUE INDEX unci_tblEventTracking ON dbo.tblEventTracking ( eventDate, eventID, VLU_ID );
    CREATE NONCLUSTERED INDEX IE1tblEventTracking ON dbo.tblEventTracking ( VEHICLE_ID, Account_ID );
    CREATE NONCLUSTERED INDEX IE2tblEventTracking ON dbo.tblEventTracking ( VEHICLE_NAME, DEG_LONGITUDE, DEG_LATITUDE );
    CREATE NONCLUSTERED INDEX IE3tblEventTracking ON dbo.tblEventTracking (SQLSystemDate );
    GO
    
    
    -- Current indexes on a table EventTracking
    -------------------------------------------------- ------------------------------------------------------- --------------------------------------------------
    --1 AK1_Tracking_eventID_VluID_eventDate           nonclustered, unique, unique key located on PRIMARY     eventID, VLU_ID, eventDate
    --2 idx_SQLSystemDate                              nonclustered located on PRIMARY                         SQLSystemDate(-)
    --3 idx_tblEventTracking_ETLCovering               nonclustered located on PRIMARY                         VEHICLE_ID, eventDate, Account_ID
    --4 D idx_Tracking_EventDate                       nonclustered located on PRIMARY                         eventDate
    --5 D idx_Tracking_EventID                         nonclustered located on PRIMARY                         eventID
    --6 D idx_Tracking_Vehicle_ID                      nonclustered located on PRIMARY                         VEHICLE_ID
    --7 idx_Tracking_Vehicle_Name                      nonclustered located on PRIMARY                         VEHICLE_NAME, eventDate, DEG_LONGITUDE, DEG_LATITUDE
    --8 PK__tblEventTracking__7211DF33                 clustered, unique, primary key located on PRIMARY       Object_ID
    --9 D XIE_eventDate_VehicleID_tblEventTracking     nonclustered located on PRIMARY                         eventDate, VEHICLE_ID
    --10 D XIE7tblEventTracking                        nonclustered located on PRIMARY                         eventID, VLU_ID


    • Edited by NguyenBL Tuesday, July 08, 2014 8:38 PM
    Tuesday, July 08, 2014 6:03 PM

Answers

All replies