Using HINTS in CountAllRecords

[cjmoore]

In part of our system we use QueryAllRecords=False with CountAllRecords=True and this generally this works OK but on certain queries the initial resultset is returned in 5 seconds but the count then takes 2.5 minutes!

Is there any way the Count(*) statement can use the optimiser hint used in the original query?

 

[Marco Kalter]

The record count function strips all comments from the original SQL for analysis purposes. As a result your hints are missing from the count statement.

We could of course restore the hints for the count statement, which I have added to the list of enhancement requests.

 

[cjmoore]

Thanks Marco, I'll look forward to that being included in 4.0.6.0!!