Thanks Arno,



I'm not at all concerned about the actual select though, I just want to know
that if I have a select, what format would it run the fastest, straight SQL,
a view or in a Stored proc...in order of precedence, and is this behaviour
consistent across all RDBMS's?



-----Original Message-----
From: Arno Brinkman [mailto:firebird@...]
Sent: Wednesday 26 November 2003 10:03
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] What is the fastest form of execution



Just straight SQL should be the fast enough, but a VIEW would be a little
faster.
Also i suggest you using UNION ALL.




[Non-text portions of this message have been removed]