Subject Re: [firebird-support] Nested Joins or Temp Tables
Author Ann Harrison
On Wed, Apr 6, 2011 at 7:20 PM, gymbratjodee <jpage@...> wrote:
> I am attempting to optimize some queries and procedures by either
> A) Creating a temp table, inserting key values from a small set of records, then using the temp table as my initial join for child tables

Firebird 1.5 doesn't support temp tables.
> B) Using a nested select (derived table) to essentially do the same thing

Firebird 1.5 doesn't support derived tables

You can move to Firebird 2.5 which supports both and test the performance
difference or you can stay with the 10 year old Firebird 1.5 (but why?) and
try to get the same effect using a view.

Good Luck,