Which method a used by the optimizer to limit the rows being returned?

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

A.
A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent
of the total rows

B.
All the rows are returned to the client or middle tier but only the first 20 percent are returned to
the screen or the application.

C.
A view is created during execution and a filter on the view limits the rows to 20 percent of the
total rows.

D.
A TOP-N query is created to limit the rows to 20 percent of the total rows

Explanation:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Extortioner

Extortioner

ะก

Marc

Marc

Predicate Information (identified by operation id):
—————————————————

1 – filter(“from$_subquery$_002”.”rowlimit_$$_rownumber”<=CEIL("from$
_subquery$_002"."rowlimit_$$_total"*20/100))

Noracle

Noracle

Marc is right. Please refer to the link he posted.
D is correct.