Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    7

    Unhappy Unanswered: Index is not faster any more

    After I have modified couple columns my database access is very slow in that table. (Update Statistics Rx_Control is in Progress). It happened before I got back to same status by restoring the data. I really don't want to restore this time. Please some one post a sloution.

    Thank you
    Raj Sankar

  2. #2
    Join Date
    Feb 2002
    Location
    India
    Posts
    15

    Re: Index is not faster any more

    Originally posted by raj_sankar
    After I have modified couple columns my database access is very slow in that table. (Update Statistics Rx_Control is in Progress). It happened before I got back to same status by restoring the data. I really don't want to restore this time. Please some one post a sloution.

    Thank you
    Raj Sankar
    Are these updates on any index columns. Try rebuilding the index using
    DBCC dbreindex

    Joe

  3. #3
    Join Date
    Aug 2002
    Posts
    7

    Re: Index is not faster any more

    Originally posted by mkg_1232000
    Are these updates on any index columns. Try rebuilding the index using
    DBCC dbreindex

    Joe
    The index is ok, Some how execution plan changed. Now every this ok after uodating the statistics. how ever the foloowing problem remains.

    from query analyser.
    select * from table_name where store = '3' ---is faster and using index scan.

    Declare @store as int
    set @store = '3'
    select * from table_name where store = @store ---is very slow and using table scan.

    I don't how to fix this, it was ok before.

Posting Permissions

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