(Hemant K Chitale) The (undocumented) CARDINALITY Hint has been available since 10g. This allowed the Developer / DBA to “hint” to Oracle the expected number of rows that will be returned from a table that is part of a query.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help