Martijn Tonies schrieb:

>
> > 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)

Just disks from ZAPPA returns 342 records, but there are also some from
Dweezil, Luis Zappa Branduardi, Zappacosta, ...

Any more statistics?

;-)

Luc.