> A query like:
> SELECT FIRST 100 * FROM
> DISCS D
> JOIN TRACKS T ON D.DISCID = T.DISCID
> WHERE D.ARTIST CONTAINING 'ZAPPA'
> needs almost nothing to execute, even though I'm using containing.

How many discs from Zappa? 100??


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com