Query optimization

 General nonsense  Add comments
Oct 122012
 

select posts
from sqlfail
where content like :this_post;

  1. MINimsing aggregate query performance to the MAX
  2. Query rewrite
  3. WITH this you can make reusable query blocks
  4. Protect your database from renegade query writers

  2 Responses to “Query optimization”

  1. Log Buffer #290, A Carnival of the Vanities for DBAs | The Pythian Blog says:
    October 12, 2012 at 16:01

    [...] Chris Saxon is fiddling his way to SQL to make it run faster. [...]

  2. Atom Wire » Blog Archive » Log Buffer #290, A Carnival of the Vanities for DBAs says:
    October 14, 2012 at 01:36

    [...] Chris Saxon is fiddling his way to SQL to make it run faster. [...]

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>