> > > 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??
>
> No the first 100 tracks of some zappa disks.
> (Which is absolutely no problem, I've got more than 100 zappa tracks on
> 30 disks)

Hmm - can't read that from your query ( select * :-)

> Just disks from ZAPPA returns 342 records, but there are also some from
> Dweezil, Luis Zappa Branduardi, Zappacosta, ...
>
> Any more statistics?

Do you have any?


With regards,

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