LBO/CBO

From: Marc Zinzen <mzinzen_at_genese.de>
Date: Fri, 27 Sep 2002 12:49:55 +0200
Message-ID: <3D9437D3.ACE15686@genese.de>

Hi.

PLAN_TABLE_OUTPUT

---

---

| Id | Operation | Name | Rows | Bytes | Cost |

---

| 0 | SELECT STATEMENT
| 1 | TABLE ACCESS FULL | T_IND_UNT | | | |

---

Note: rule based optimization
The Problem is the Note at the Bottem. Rule bases optimization. I did an alter session set optimizer_mode = choose; Still it says rule based. But i want to do this query Cost based. Where is the switch????? Does anybody know. Marc Received on Fri Sep 27 2002 - 05:49:55 CDT