problems with explain plan in 9i EE for linux

From: Sławomir Marcinkowski <s.marcinkowski_at_Bankier.pl>
Date: Thu, 14 Feb 2002 09:45:13 +0100
Message-ID: <a4ftdd$2e6$1@news.tpi.pl>

if I call query like this one:
EXPLAIN PLAN
INTO plan_table
FOR
select * from emp;

and run script: @utlxpls.sql, I always get:

Plan Table

---

---

| Operation                 |  Name              |  Rows | Bytes|  Cost  |

Pstart| Pstop |

---

---

| SELECT STATEMENT          |                    |       |      |        |
|       |
|  TABLE ACCESS FULL        |EMP                 |       |      |        |
|       |


----------------------------------------------------------------------------

---

I mean, that where is no rows, bytes, cost, etc. What should I do, to correct it?

Slawek,
Poland Received on Thu Feb 14 2002 - 02:45:13 CST