Prev: DECODE
Next: How to auto-enable a password protected role
From: Jia Lu on 18 Apr 2010 22:05
Hi all

I have an explain plan like below. and I doubt about the COST.
How is the COST be calculated? I mean what does that mean? (CPU
rate?)

SQL> @?/rdbms/admin/utlxpls.sql

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1764098166

------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)|
Time |
------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 7824 (1)|
00:01:34 |
| 1 | SORT AGGREGATE | | 1 |
| |
| 2 | INDEX FAST FULL SCAN| BIG_TABLE_PK | 6812K| 7824 (1)|
00:01:34 |
------------------------------------------------------------------------------

Thanks alot.

Lu
From: Jia Lu on 19 Apr 2010 21:23
On 4月19日, 午後6:51, Randolf Geist <mah...(a)web..de> wrote:
Thanks for your answer.
You told me something internal :)

I think I should purse your book to study.

Best
Lu
 | 
Pages: 1
Prev: DECODE
Next: How to auto-enable a password protected role