Alternative to FOUND_ROWS()
Posted by: jun kazawa
Date: February 08, 2009 01:07PM

FOUND_ROWS is convenient when you have to get the count of all rows from a SELECT SQL_CALC_FOUND_ROWS that contains a LIMIT clause.

However we need the count(*) of a query from a huge table where we want the count to be limited to a given number (e.g. 1000). It is almost the opposite of FOUND_ROWS().

We want actually to take advantage of the indexes and the LIMIT algorithm that reduce the number of rows examined, without returning the actual rows - just the count. The count would be actually and virtually MIN(Limit_given, count(*))

Is it possible to get such a limited count(*)?

Options: ReplyQuote

Written By
Alternative to FOUND_ROWS()
February 08, 2009 01:07PM
February 10, 2009 12:08AM
February 11, 2009 10:21AM
February 14, 2009 01:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.