SQL Script optimization/tuning

Posted on 2009-02-09
Last Modified: 2013-11-16
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)


Question by:Nakuru1234
    1 Comment
    LVL 23

    Accepted Solution

    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?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
    Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now