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

Sivaraman