• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

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_date 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
0
Nakuru1234
Asked:
Nakuru1234
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
Is there a difference between id and subscriber_id?  Please be consistent.  And, what version database?
Your start_time_2 is redundant, in that the columns are already indexed.
What are the table columns and datatypes?  How are you using the DATE related columns?
 
 
 
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now