#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    30
    Rep Power
    2

    Question What index do I need?


    It seems certain queries search by the number of days to ship(number of days between the order and shipping dates). What kind of index would improve the performance of these queries?
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    848
    Rep Power
    387

    Thumbs down


    Originally Posted by darthvader45
    It seems certain queries search by the number of days to ship(number of days between the order and shipping dates). What kind of index would improve the performance of these queries?
    Answer: You will need the index you have not thought about.

    - You provide no query
    - You provide no table definitions
    - You provide no explain plan

    Our crystal ball is broken and we cannot guess what you want.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    30
    Rep Power
    2
    Originally Posted by LKBrwn_DBA
    Answer: You will need the index you have not thought about.

    - You provide no query
    - You provide no table definitions
    - You provide no explain plan

    Our crystal ball is broken and we cannot guess what you want.
    Nvm, figured it out. Have a mod delete this topic.

IMN logo majestic logo threadwatch logo seochat tools logo