First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Notes continued from the previous page:

SQL> select /*dave:force*/ * from big where object_type = 'SYNONYM';

12547 rows selected.

Execution Plan
--------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=52 Car
1 0 TABLE ACCESS (FULL) OF 'BIG' (Cost=52 Card=1

Given the problems related to the cursor sharing feature, perhaps a better approach to cursor sharing is to avoid this feature or use it only as a short-term fix while the application is enhanced to incorporate the proper use of bind variables.