Nakuru1234
asked on
SQL Script optimization/tuning
I am thinking of adding more indexes on
1. index_end_date for column end_time
2. index_billing_cycle_end_da te for column billing_cycle_end_date
But I am not sure if that is ok. Please advice. TIA.
Table: Udr
Current Indexes:
1. id
2. start_time (start_time, end_time, subscriber_id)
3. start_time_2 (start_time, subscriber_id)
TIA,
V.
SQL-ANALYZE-MON92009.txt
1. index_end_date for column end_time
2. index_billing_cycle_end_da
But I am not sure if that is ok. Please advice. TIA.
Table: Udr
Current Indexes:
1. id
2. start_time (start_time, end_time, subscriber_id)
3. start_time_2 (start_time, subscriber_id)
TIA,
V.
SQL-ANALYZE-MON92009.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.