> First table is containing 40,000 records and second table contains
> some 10,000 records.
>
> Why is it very slow?We checked the indexing also.My dba told it is
> perfect.
>
> Need a solution soon

For what? What is slow?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com