Hosting Provided By

Re: [GENERAL] Would an index benefit select ... order by?

From: A. Kretschmer <andreas.kretschmer(at)schollglas.com>
Date: Sat Nov 03 2007 - 03:33:44 EDT

am Sat, dem 03.11.2007, um 11:09:05 +0400 mailte rihad folgendes:
> Hi,
>
> Should an index be used on a created_at timestamp column if you know you
> will be using "ORDER BY created_at ASC|DESC" from time to time?

Yes. And you should use EXPLAIN.

Andreas

-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   
http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Received on Sat Nov 3 03:35:40 2007

This message: [ Message body ]
Next message: rihad: "[GENERAL] index usage in joins q'n"
Previous message: Mikko Partio: "Re: [GENERAL] Populating large DB from Perl script"
In reply to: rihad: "[GENERAL] Would an index benefit select ... order by?"
Next in thread: rihad: "Re: [GENERAL] Would an index benefit select ... order by?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 19:17:27 EDT