What does the COST(%CPU) in explain plan mean?
From: Jia Lu <roka100_at_gmail.com>
Date: Sun, 18 Apr 2010 19:05:53 -0700 (PDT)
Message-ID: <40d15b1b-6ffd-46ae-a337-9fcfc75bad77_at_b23g2000yqn.googlegroups.com>
Hi all
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 |
Date: Sun, 18 Apr 2010 19:05:53 -0700 (PDT)
Message-ID: <40d15b1b-6ffd-46ae-a337-9fcfc75bad77_at_b23g2000yqn.googlegroups.com>
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> _at_?/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 Received on Sun Apr 18 2010 - 21:05:53 CDT