Re: [GENERAL] Query Cost

2005-09-18 Thread Jim C. Nasby
On Sun, Sep 18, 2005 at 07:40:26PM +0100, ShepherdHill DB Subscriptions wrote: > Hi, > > I have a table with this schema: > > CREATE TABLE billing.bill > ( > sno serial NOT NULL, > billno int4, > det date NOT NULL, > . > . > . > CONSTRAINT bill_pkey PRIMARY KEY (sno) > ) > > I want to

[GENERAL] Query Cost

2005-09-18 Thread ShepherdHill DB Subscriptions
Hi, I have a table with this schema: CREATE TABLE billing.bill ( sno serial NOT NULL, billno int4, det date NOT NULL, . . . CONSTRAINT bill_pkey PRIMARY KEY (sno) ) I want to execute a query that will not return any record. Which of these queries is cheaper please? 1. Select * from