Thread: order by and indices

order by and indices

From

Felipe Schnack

Date:

06 January 2003, 17:49:04

  Hey all
  quick question: creating indices on a table may speed up ORDER BY
clauses?

--

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone/Fax.: (51)32303341

Re: order by and indices

From

Alan Gutierrez

Date:

06 January 2003, 20:05:29

Felipe Schnack wrote:
> Hey all
> quick question: creating indices on a table may speed up ORDER BY
> clauses?

Short answer yes. Explain will tell you more - G