Subject Re: [firebird-support] Re: Query help: getting non used records in a table
Author Martijn Tonies
> you don't need an auxilary table to do this.
> You can write a small SP to do suspend used (or unused) numbers via
> cursor(plus counter) loop. This will be more economic.

Not always. When doing JOINs for example, this won't be
a join with an indexed table, but with a resultset (from the
procedure) that's being generated "on the fly". This could get

> You know,
> To be a Firebirder means of to be speedy-homoeconomicus-gonzales.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!