At 09:44 AM 21/02/2003 +1000, you wrote:

>Well, that's not what we are doing, but you may be onto it. Is there some
>explanation of this on the web that you could point me to?

Not that I know of; although it would be a great idea to have a paper
available. Have you tried googling the subject?

I'll be presenting topics on database design at the forthcoming Firebird
conference in May. Indexing issues will be in there for certain. I'm sure
all of the proceedings will come out as white papers afterwards....but it
doesn't help you right now.

Do as Svein suggests: pick out the slow queries and raise a question
here. If you don't have one, get hold of a client tool which shows you the
plans for your queries. You can actually do this with command-line isql,
using the -planonly switch.

cheers,
heLen