User Profile

Collapse

Profile Sidebar

Collapse
rlowson
rlowson
Last Activity: May 20 '10, 05:50 PM
Joined: Mar 15 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rlowson
    replied to When will a LIKE expression use an index?
    in SQL Server
    Yes, the table does have an index on the column in question. The table contains about 100,000 records, and since recently adding the LIKE expression to the procedure, I have lost about half a second to a second (this is part of an auto-suggestion feature, which is why the speed is important to me).
    See more | Go to post

      Leave a comment:

    • rlowson
      started a topic When will a LIKE expression use an index?
      in SQL Server

      When will a LIKE expression use an index?

      I have a stored procedure that is taking a longer than is reasonable to execute, and I have isolated the part that is costing me the most. It is the part that uses a LIKE expression. Here is the sub query in question:

      @partial_vernac ular is the stored procedure parameter that contains the text I want to match on.

      DECLARE @searchlike nvarchar(100);
      SET @searchlike = @partial_vernac ular +'%';

      SELECT...
      See more | Go to post
      No activity results to display
      Show More
      Working...