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
