Re: [firebird-support] select with constant value in where-clause

 

As an amateur - I'd suggest using an indexed field in the where clause, and choosing an invalid value that is less than the 1st real entry.

 

--

Daniel

 

 

------ Original Message ------

From: "Josef.Gschwendtner@Quattro-Soft.de [firebird-support]" <firebird-support@yahoogroups.com>

To: firebird-support@yahoogroups.com

Sent: 12/19/2015 9:46:02 AM

Subject: [firebird-support] select with constant value in where-clause

 

Hi,

the following select fetches all records of the table (FB 2.5.4) and obviously brings no resultset.

select * from Mytable where 1=0

Is there a trick to force Firebird not to scan all records?

We sometimes use such a statement (in for select loops) to get different datasets and process it in the loop.
select ... from Table1 where :InputParam = 'A'
union

select ... from Table2 where :InputParam = 'B'

Regards,

Josef

__._,_.___

---

Posted by: "Daniel Miller" <dmiller@amfes.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___