Slow query with cfqueryparam searching on indexed column containing hashes

by

Your issue may be related to VARCHAR vs NVARCHAR. These 2 links may help
Querying MS SQL Server G/UUIDs from ColdFusion and
nvarchar vs. varchar in SQL Server, BEWARE

What might be happening is there is a setting in ColdFusion administrator if cfqueryparam sends varchars as unicode or not. If that setting does not match the column setting (in your case, if that setting is enabled) then MS SQL will not use that index.

More Related Contents:

  1. What makes a SQL statement sargable?
  2. What do Clustered and Non-Clustered index actually mean?
  3. Which are more performant, CTE or temporary tables?
  4. SQL Server: Query fast, but slow from procedure
  5. XML Server XML performance optimization
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. SQL Server pivot vs. multiple join
  8. LIKE vs CONTAINS on SQL Server
  9. SQL Server Query: Fast with Literal but Slow with Variable
  10. Does the order of columns in a WHERE clause matter?
  11. cross apply xml query performs exponentially worse as xml document grows
  12. Which is quicker COALESCE OR ISNULL?
  13. How to multiply column in Sql
  14. What is the best way to create and populate a numbers table?
  15. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  16. How do you clear the SQL Server transaction log?
  17. How Can I Log and Find the Most Expensive Queries?
  18. SQL Server truncation and 8192 limitation
  19. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  20. How to list all dates between two dates [duplicate]
  21. Number of times a particular character appears in a string
  22. SQL Server variable columns name?
  23. What is the point of “Initial Catalog” in a SQL Server connection string?
  24. How can I know when SQL Full Text Index Population is finished?
  25. SQL Server – defining an XML type column with UTF-8 encoding
  26. What does “exec sp_reset_connection” mean in Sql Server Profiler? [duplicate]
  27. What datatype should be used for storing phone numbers in SQL Server 2005?
  28. The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
  29. Full text catalog/index search for %book%
  30. How to do Sql Server CE table update from another table

Leave a Comment