Subject Re: slow join?
Author bwc3068

Thanks again. I found that article and read it. Thanks for the pointer.

I'll also read through other posts with "index statistics".

I'm very happy with the speed. It's rare users will want to see all that data joined and when they do, 50 seconds for 500,000 records is very acceptable.

Thanks again

--- In, "emb_blaster" <EMB_Blaster@...> wrote:

> I'm quite sure you did it right way. But sometimes you may need "backup'n'restore". Also, you can go further reading old messages, look for index statistics, or index selectivity... you will find usefull. Also Ann Harrison has a papper in IBPhoenix that is a must read for understanding index... (acctualy, I must admit that I'm not really wise in Firebird's subjects yet.. :(
> anyway, I didn't like wait 50 sec. Are you sure this is acceptable?
> SY,