Link Details

Link 854587 thumbnail
User 449508 avatar

By lionofdezert
via connectsql.blogspot.com
Published: Sep 26 2012 / 02:54

Just creating indexes on JOIN, WHERE and GROUP clause columns doesn’t mean that your query will always return your required results quickly. Specially when you have applied TRIM or any other function in WHERE clause. It can really damage your query performance.
  • 8
  • 0
  • 443
  • 348

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (8)



Voters Against This Link (0)



    Java EE7
    Written by: Andrew Lee Rubinger
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. CI Patterns
    5. CI Tools
    1. Spring Integration
    2. Git
    3. Regex
    4. Java
    5. REST