X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id DE090DB03D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 27 Oct 2005 04:26:39 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 13256-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 27 Oct 2005 07:26:37 +0000 (GMT)
Received: from mx1.mimos.my (mx1.mimos.my [192.228.137.109])
	by svr1.postgresql.org (Postfix) with ESMTP id 0A65FDB01E
	for <pgsql-sql@postgresql.org>; Thu, 27 Oct 2005 04:26:38 -0300 (ADT)
Message-ID: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>
From: Abdul Wahab Dahalan <wahab@mimos.my>
To: pgsql-sql@postgresql.org
Subject: How to speed up the database query?
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Priority: 3 (normal)
X-Mailer: SuSE Linux Openexchange Server 4 - WebMail (Build 2.3788)
X-Operating-System: Linux 2.4.21-198-smp i386 (JVM 1.3.1_04)
Organization: MIMOS Berhad
Date: Thu, 27 Oct 2005 15:03:36 +0800 (MYT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 required=5 tests=[none]
X-Spam-Level: 
X-Archive-Number: 200510/353
X-Sequence-Number: 23206

Hi everyone!

I'm looking for solution to speed up the database query, means that to get resultset as quicker as we can.

For example if I've 700 records in the table it will take longer time compared if I've only 20 records. How do we speed up the query?. Any query technique that can be applied?.

Thus wild card query like : select * from tableA will cause query time increased compare to say select a,b from tableA.

any help, prettymuch appreciated.