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
  • 488
  • 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.

Apache Hadoop
Written by: Piotr Krewski
Featured Refcardz: Top Refcardz:
  1. Play
  2. Akka
  3. Design Patterns
  4. OO JS
  5. Cont. Delivery
  1. Play
  2. Java Performance
  3. Akka
  4. REST
  5. Java