songlist & categorylist do not appear to have any relevant indecies, both
fields in

songlist join categorylist on (songlist.ID = categorylist.songID)

should be indexed

>From: "Louis Louw" <louis@...>

>Having a problem with a slow query in FireBird.

_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile