Run an analyse on your query, create your indexes according to that, and you have a better performing query. Getting a resultset display faster will depend on your driver/RAM/client
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Abdul Wahab Dahalan Sent: Thursday, October 27, 2005 12:34 PM To: pgsql-sql@postgresql.org Subject: [SQL] How to speed up the database query? 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
