Results 1 to 2 of 2

Thread: Question on Indexes

  1. 11-13-2006, 10:25 AM #1
    bobkand
    bobkand is offline Registered User
    Join Date
    Sep 2005
    Posts
    43

    Question Question on Indexes

    I got a huge table with a Clustered index on it, when i was querying the same table based on date column....I foud a weird thing...The common Select statement is fast for date before '08/10/2006' and after that for all the days like 9th, 10th, 11th, 12th or 13th the select statment is running for ever.

    Then, I dropped my index and recreated it, then it was fine for all dates.

    Why it happened? and what is the better way to solve it..?
    Reply With Quote Reply With Quote
  2. 11-13-2006, 10:55 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You need update statistics on the table more often.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules