Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [GENERAL] Optimization problem?



On Tue, 1 Sep 1998, Jerome Knobl wrote:

// I'm working with a table with about 650'000 rows. It's working
// pretty well, my queries take about 20 seconds.
// 
// I would like to know to optimize it ?

	Given the information provided, I'd recommend buying a SQL book.
You also might want to add an index or two (the SQL book would tell you
all about it).

--
SA, software.net         My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE 
L_______________________ I hope the answer won't upset her. ____________




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group