Thnks Phil, You hit the nail on the head. Problem solved :) Mark. >I'm pretty sure I have seen a similar post before. The problem is that >Postgres assumes the constant you are using is an int4. Try casting it to >int8 and see if that helps. > >SELECT * FROM ClientTable WHERE ClientNumber=1234566789::int8; > > >Phil Culberson >DAT Services > >-----Original Message----- >From: Mark Alliban [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 02, 2000 10:16 AM >To: [EMAIL PROTECTED] >Subject: [GENERAL] Re: Poor performance - need advice > > >>We have a table with 95,000 records, indexed on an int8 type >(ClientNumber). >>It is currently taking up to 10 seconds to retrieve one row based upon the >>following statement: >> >>SELECT * FROM ClientTable WHERE ClientNumber=1234566789; >> >>The client numbers are random and there is currently no locking on the >>database. I am running SCO OpenServer, PostgreSQL version 6.5.3. Is there >>any way we can reduce the time taken by this query? > > >I have tried an EXPLAIN of the above statement, and it tells me that >Postgres is doing a Seq Scan on the table to return the results, even though >it should be using the index. How can I make sure that it will always use >the index when I specify ClientNumber? > > >************ > >************ > ************
