|Subject||Re: [firebird-support] Sloooow query|
> > > A query like:Hmm - can't read that from your query ( select * :-)
> > > 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 fromDo you have any?
> Dweezil, Luis Zappa Branduardi, Zappacosta, ...
> Any more statistics?
Database Workbench - the developer tool for InterBase & Firebird