Link Details

Link 854587 thumbnail
User 449508 avatar

By lionofdezert
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
  • 474
  • 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)

    Reactive Programming with Akka
    Written by: Ryan Knight
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java Performance
    5. HTML5 Mobile
    1. Java Performance
    2. Node.js
    3. Debugging JavaScript
    4. Java
    5. Java Concurrency