Hi guys

In Toad 8.5.3, if I right-click the result of a simple select query and choose 'Record Count', things just freeze.

Basically, there are 3 sections to the query each joined using 'union all'. The other two very similar sections return results as does the third (within a minute, 1100 rows each), however, the other two also return the 'Record Count' within a minute but the third section takes toooooo long, so much so that I have to cancel the operation.

Would anyone have any ideas?

Regards
Shajju