Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan assistance needed

Re: explain plan assistance needed

From: <beijingshenao2008_at_yahoo.com.cn>
Date: Mon, 04 Jun 2007 22:58:57 -0700
Message-ID: <1181023137.005134.277210@r19g2000prf.googlegroups.com>


SHINE international trade company
Sorry to trouble you.
please read this mail. It's for your career
>From shine international trade Company of Beijing. China
Dear sir/madam:

        Thank you for read this mail. Our company in china. Like you think, china is ready To be world's factory. We have all kinds of things. Of course. We have best manpower resource , best price. More and more person, company like to build trade company in china. It is our predominance. Like light industry, Sinitic things. and a lot of other things need us to do. It's a chance for us. That's right.

        Until this, I want you know, our company now do business about like shoes, bags, belts, clothing, PSP, glasses jeans and so on. Our company want to look for a cooperate friend in your state. If you agree our company case. If you want to pay just a computer to do something. If you have a trade company in your state. Or if you have a shop(online shop)You can call us to talk about next step. We will give the best price, best service. The shine international shine trade will like to talk to you very much.

         You can go to our website http://www.6thshop.com/bbs.asp to leave massage
 MSN:evenbeijing_at_hotmail.com

	 yahoo:  shinechina_at_yahoo.com.cn
	 E-mail:   even-china_at_hotmail.com
	 http://www.6thshop.com
	 phone: 86-13811619431
	 FAX: 86-10-51670319
	             GOOD LUCK!
			        								       EVEN FROM CHINA
------- SHINE INTERNATIONAL TRADE COMPANY OF BEIJING.CHINA
> /
> select plan_table_output from
> table(dbms_xplan.display('plan_table',null,'all'))
> /
> CREATE INDEX nix_QARUNSTATS_FILE ON QARUNSTATS_FILE x
> (NVL(NUMCAST(extractValue(x.xmlcol,'/row/path')),0))
> /
> explain plan for select count(RECID) from qarunstats_file x where
> NVL(NUMCAST(extractValue(x.xmlcol,'/row/path')),0) = 5
> /
> select plan_table_output from
> table(dbms_xplan.display('plan_table',null,'all'))
> /
> begin dbms_stats.gather_table_stats('SCOTT','QARUNSTATS_FILE'); end;
> /
> explain plan for select count(RECID) from qarunstats_file x where
> NVL(NUMCAST(extractValue(x.xmlcol,'/row/path')),0) = 5
> /
> select plan_table_output from
> table(dbms_xplan.display('plan_table',null,'all'))
> /
> begin dbms_stats.gather_table_stats('SCOTT','QARUNSTATS_FILE'); end;
> /
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 09:54:20 2007
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> Connected to:
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
>
> Index dropped.
>
> PL/SQL procedure successfully completed.
>
> COUNT(RECID)
> ------------
> 100000
>
> COUNT(RECID)
> ------------
> 4508
>
> Explained.
>
> PLAN_TABLE_OUTPUT
> --------------------------------------------------------------------------------
> Plan hash value: 37407764
>
> --------------------------------------------------------------------------------
> ------
>
> | Id | Operation | Name | Rows | Bytes | Cost
> (%CPU)| Time
> |
>
> --------------------------------------------------------------------------------
> ------
>
> | 0 | SELECT STATEMENT | | 1 | 185 | 572
> (14)| 00:0
> 0:07 |
>
> | 1 | SORT AGGREGATE | | 1 | 185
> | |
> |
>
> |* 2 | TABLE ACCESS FULL| QARUNSTATS_FILE | 992 | 179K| 572
> (14)| 00:0
> 0:07 |
>
> --------------------------------------------------------------------------------
> ------
>
> Query Block Name / Object Alias (identified by operation id):
> -------------------------------------------------------------
>
> 1 - SEL$1
> 2 - SEL$1 / X_at_SEL$1
>
> Predicate Information (identified by operation id):
> ---------------------------------------------------
>
> 2 -
> filter(NVL("NUMCAST"(EXTRACTVALUE(SYS_MAKEXML("X"."SYS_NC00003$"),'/
> row
> /value')),0)=5)
>
> Column Projection Information (identified by operation id):
> -----------------------------------------------------------
>
> 1 - (#keys=0) COUNT(*)[22]
>
> 26 rows selected.
>
> Index created.
>
> Explained.
>
> PLAN_TABLE_OUTPUT
> --------------------------------------------------------------------------------
> Plan hash value: 1724735628
>
> --------------------------------------------------------------------------------
> ------------
>
> | Id | Operation | Name | Rows | Bytes |
> Cost (%CPU)
> | Time |
>
> --------------------------------------------------------------------------------
> ------------
>
> | 0 | SELECT STATEMENT | | 1 | 185
> | 1 (0)
> | 00:00:01 |
>
> | 1 | SORT AGGREGATE | | 1 | 185 |
> | |
>
> |* 2 | INDEX RANGE SCAN| NIX_QARUNSTATS_FILE | 992 |
> 179K| 1 (0)
> | 00:00:01 |
>
> --------------------------------------------------------------------------------
> ------------
>
> Query Block Name / Object Alias (identified by operation id):
> -------------------------------------------------------------
>
> 1 - SEL$1
> 2 - SEL$1 / X_at_SEL$1
>
> Predicate Information (identified by operation id):
> ---------------------------------------------------
>
> 2 -
> access(NVL("SCOTT"."NUMCAST"(EXTRACTVALUE(SYS_MAKEXML("SYS_NC00003$"),'/
> row
> /value'
>
> )),0)=5)
>
> Column Projection Information (identified by operation id):
> -----------------------------------------------------------
>
> 1 - (#keys=0) COUNT(*)[22]
>
> 26 rows selected.
>
> PL/SQL procedure successfully completed.
>
> Explained.
>
> PLAN_TABLE_OUTPUT
> --------------------------------------------------------------------------------
> Plan hash value: 1724735628
>
> --------------------------------------------------------------------------------
> ------------
>
> | Id | Operation | Name | Rows | Bytes |
> Cost (%CPU)
> | Time |
>
> --------------------------------------------------------------------------------
> ------------
>
> | 0 | SELECT STATEMENT | | 1 | 185
> | 1 (0)
> | 00:00:01 |
>
> | 1 | SORT AGGREGATE | | 1 | 185 |
> | |
>
> |* 2 | INDEX RANGE SCAN| NIX_QARUNSTATS_FILE | 4456 |
> 805K| 1 (0)
> | 00:00:01 |
>
> --------------------------------------------------------------------------------
> ------------
>
> Query Block Name / Object Alias (identified by operation id):
> -------------------------------------------------------------
>
> 1 - SEL$1
> 2 - SEL$1 / X_at_SEL$1
>
> Predicate Information (identified by operation id):
> ---------------------------------------------------
>
> 2 -
> access(NVL("SCOTT"."NUMCAST"(EXTRACTVALUE(SYS_MAKEXML("SYS_NC00003$"),'/
> row
> /value'
>
> )),0)=5)
>
> Column Projection Information (identified by operation id):
> -----------------------------------------------------------
>
> 1 - (#keys=0) COUNT(*)[22]
>
> 26 rows selected.
>
> PL/SQL procedure successfully completed.
>
> Disconnected from Oracle Database 10g Express Edition Release
> 10.2.0.1.0 - Production
> SQL> show parameters statistic
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> statistics_level string TYPICAL
> timed_os_statistics integer 0
> timed_statistics boolean FALSE
> SQL>
>
> NUMCAST function
> ================
> create function numcast(value in VARCHAR) return NUMBER deterministic
> as
> rtnval NUMBER;
> begin
> rtnval := TO_NUMBER(value);
> return rtnval;
> exception
> when others then
> return NULL;
> end;
> /
Received on Tue Jun 05 2007 - 00:58:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US