Thanks for your help.

But i had one more question, Will this statistics help in query tuning? How?

1CR means 10 million records. You are right but as it is a case study and I had to create a report, now please can you help me on this.

First of all thank you for ur reply.

We are writing the log as per your 3 step.

I have created 3 packages

But our actual working for the log is as follows,

First...

It is not possible to post the structure. Please if you have any alternatives of it then please help me.

This query takes 10 min to find out 1000 records.

Please help me in tuning the query.

I think the SP procedure is good but i am not able to see any out put. Please can you let me know hoe to use the SP, as it...