shilpa.raghavendra@wipro.com wrote:
> The report contains more than 70,000 records but it takes more
> than half an hour and some time no result.
>
> Please help me to generating the report fast.
You'll need to provide some more information before anyone can help.
Something along the lines of:
- table definitions
- query definition
- EXPLAIN ANALYSE output (or just plain EXPLAIN if that's not practical)
--
Richard Huxton
Archonet Ltd