Saturday, May 11, 2013

ADF 11G : getRowCount() Vs getEstimatedRowCount()

getRowCount() Vs getEstimatedRowCount()

getRowCount(): This method fetches all rows from Database than it counts

getEstimatedRowCount() : This fires the count queries. It takes help from getQueryHitCount() to find the row count.

Which one is Preferable ?

getEstimatedRowCount() is preferable.