Vladimir Podolyaka
Member
Hello,
Could somebody give me a hint, is it possible to change the standard "select count(*) from (OracleDataSet.SQL)", when the CountAllRecord = true is used? I need it to improve the speed of this query. For example, when the query contains SQL statement like
select fun_1(field_1), ..., fun_n(field_n) from ... . I don't think the it's nice to calculate all fan_1()...fan_n() to get record count.
Best regards,
Vladimir.
Could somebody give me a hint, is it possible to change the standard "select count(*) from (OracleDataSet.SQL)", when the CountAllRecord = true is used? I need it to improve the speed of this query. For example, when the query contains SQL statement like
select fun_1(field_1), ..., fun_n(field_n) from ... . I don't think the it's nice to calculate all fan_1()...fan_n() to get record count.
Best regards,
Vladimir.