`\u8868\u5206\u6790\u4e0e\u7d22\u5f15\u5206\u6790
\nanalyze table HSC_REC_PRODUCT2004 compute statistics
\nanalyze index PK_HSC_REC_PRODUCT2004 compute statistics
\n--\u540c\u65f6\u5206\u6790\u8868\u4e0e\u7d22\u5f15
\nEXEC dbms_stats.gather_table_stats('FSHSC','HSC_REC_PRODUCT2004',CASCADE=>TRUE) ;<\/p>\n
\/ truncate table test; alter table test nologing on; alter session enable parallel dml; \/\/\u5f00\u542f\u5e76\u53d1\u6a21\u5f0f select \/+ parallel(4) <\/em>\/ count(*) from test;<\/p>\n analyze table test compute statistics; --\u5b8c\u6210\u5206\u6790\uff0c\u6bd4\u8f83\u6162\uff0c<\/p>\n select \/+ parallel(4)<\/em>\/ * from test where username ='test_5000094';<\/p>\n select from test where username ='test_5000094'; select count(*) from test where CHANGEDATE>to_date('2014-09-28 09:38:11','yyyy-mm-dd hh24:mi:ss') and CHANGEDATE<to_date('2014-09-28 09:38:13','yyyy-mm-dd hh24:mi:ss');<\/p>\n ALTER INDEX test_change UNUSABLE; select count(*) from test where CHANGEDATE>to_date('2014-09-28 09:38:11','yyyy-mm-dd hh24:mi:ss') and CHANGEDATE<to_date('2014-09-28 09:38:13','yyyy-mm-dd hh24:mi:ss');<\/p>\n ALTER INDEX test_change DISABLE | ENABLE; alter index test_username rebuild; \/\u4f7f\u7528\u7d22\u5f15\u751f\u6548,\u91cd\u5efa\u7d22\u5f15<\/em>\/ \u8868\u5206\u6790 analyze table test compute statistics; --\u5b8c\u6210\u5206\u6790\uff0c\u6bd4\u8f83\u6162\uff0c \u4e5f\u5c31\u662f\u8bf4\u53ea\u6709\u57fa\u4e8e\u51fd\u6570\u7684\u7d22\u5f15\u624d\u80fd\u4e34\u65f6\u7981\u7528\u548c\u542f\u7528\u3002<\/p>\n ALTER INDEX indexname UNUSABLE; d:\\oracle\\product\\10.2.0\\db_1\\bin;%SystemRoot%\\system32;%SystemRoot%;%SystemRoot%\\System32\\Wbem;%SYSTEMROOT%\\System32\\WindowsPowerShell\\v1.0\\;D:\\Program Files\\Java\\jdk1.6.0_10\\jre\\bin;D:\\Program Files\\Java\\jdk1.6.0_10\\bin;D:\\Program Files\\TortoiseSVN\\bin;C:\\strawberry\\c\\bin;C:\\strawberry\\perl\\bin;D:\\Android\\android-sdk-windows\\platform-tools;D:\\Android\\android-sdk-windows\\tools;C:\\Program Files\\jEdit;C:\\Program Files\\MySQL\\MySQL Server 5.7\\bin;C:\\Python27;C:\\Program Files\\MySQL\\MySQL Server 5.6\\bin;E:\\Tools\\apache-ant-1.8.2\\bin;F:\\jmeter\\bin `\u8868\u5206\u6790\u4e0e\u7d22\u5f15\u5206\u6790 analyze table HSC_REC_PRODUCT2004 compute statistics analyze index PK_HSC_REC_PRODUCT2004 compute statistics –\u540c\u65f6\u5206\u6790\u8868\u4e0e\u7d22\u5f15 EXEC dbms_stats.gather_table_stats(‘FSHSC’,’HSC_REC_PRODUCT2004′,CASCADE=>TRUE) ; \/ Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@172.20.23.118:1521:oracle"; \/\/ \u8fde\u63a5\u6570\u636e\u5e93\u7684URL test\/test@oracle create table test( userid number(15) not null, username char(20), userpwd char(20), sex char(2), age number(5), intrest varchar(2000), changedate date, role char(2) default 0, primary key (userid,username) ); \/ create index test_username on test(username); create index test_change on test(to_date(changedate,’yyyy-mm-dd hh24:mi:ss’)); truncate table test; set timing on; alter table test nologing on; CREATE or REPLACE PROCEDURE inserttest as userid number(7):=5000000; begin For i In 1 .. 5000000 Loop Insert Into test Select Lpad(ToChar(userid), 7, ‘0’), ‘test’||Lpad(ToChar(userid), 7, ‘0’), ‘test’||Lpad(To_Char(userid), 7, ‘0’), decode(Mod(i,2),0,’0′,1,’1′),21 , ‘adklfs’, sysdate,decode((Mod(i,2)),0,’0′,1,’1′) from dual; userid:=userid+1; If Mod(i,10000)=0 then Commit; End If; End Loop; end; \/ exec inserttest; commit; alter session enable parallel dml; \/\/\u5f00\u542f\u5e76\u53d1\u6a21\u5f0f Alter Table test Parallel; \/\/\u5f00\u542f\u8868\u7684\u5e76\u53d1\u6a21\u5f0f Alter Table test NOLOGGING; \/\/\u5173\u95ed\u64cd\u4f5c\u65e5\u5fd7: Alter Table test noParallel; \/\/\u5173\u95ed\u5e76\u53d1 Alter Table test LOGGING; \/\/\u6253\u5f00\u64cd\u4f5c\u65e5\u5fd7 select \/+ parallel(4) \/ count(*) from test; analyze table test compute statistics; –\u5b8c\u6210\u5206\u6790\uff0c\u6bd4\u8f83\u6162\uff0c select \/+ parallel(4)\/ * from test where username =’test_5000094′; select from test where username =’test_5000094′; select \/+ INDEX(test,test_username)\/ from test where username =’test_5000094′; select count(*) from test where CHANGEDATE>to_date(‘2014-09-28 09:38:11′,’yyyy-mm-dd hh24:mi:ss’) and CHANGEDATE<to_date(‘2014-09-28 09:38:13′,’yyyy-mm-dd hh24:mi:ss’); ALTER INDEX test_change UNUSABLE; ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE; select count(*) from test where CHANGEDATE>to_date(’20…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82,100,80],"tags":[],"class_list":["post-1587","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82","category-100","category-80"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1587"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1587\/revisions"}],"predecessor-version":[{"id":1588,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1587\/revisions\/1588"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nClass.forName("oracle.jdbc.driver.OracleDriver");
\nString url = "jdbc:oracle:thin:@172.20.23.118:1521:oracle"; \/\/ \u8fde\u63a5\u6570\u636e\u5e93\u7684URL
\ntest\/test@oracle
\ncreate table test(
\nuserid number(15) not null,
\nusername char(20),
\nuserpwd char(20),
\nsex char(2),
\nage number(5),
\nintrest varchar(2000),
\nchangedate date,
\nrole char(2) default 0,
\nprimary key (userid,username)
\n);
\n<\/em>\/
\ncreate index test_username on test(username);
\ncreate index test_change on test(to_date(changedate,'yyyy-mm-dd hh24:mi:ss'));<\/p>\n
\nset timing on;<\/p>\n
\nCREATE or REPLACE PROCEDURE inserttest
\nas
\nuserid number(7):=5000000;
\nbegin
\nFor i In 1 .. 5000000 Loop
\nInsert Into test
\nSelect Lpad(ToChar(userid), 7, '0'), 'test<\/em>'||Lpad(ToChar(userid), 7, '0'), 'test<\/em>'||Lpad(To_Char(userid), 7, '0'),
\ndecode(Mod(i,2),0,'0',1,'1'),21 , 'adklfs',
\nsysdate,decode((Mod(i,2)),0,'0',1,'1')
\nfrom dual;
\nuserid:=userid+1;
\nIf Mod(i,10000)=0 then
\nCommit;
\nEnd If;
\nEnd Loop;
\nend;
\n\/
\nexec inserttest;
\ncommit;<\/p>\n
\nAlter Table test Parallel; \/\/\u5f00\u542f\u8868\u7684\u5e76\u53d1\u6a21\u5f0f
\nAlter Table test NOLOGGING; \/\/\u5173\u95ed\u64cd\u4f5c\u65e5\u5fd7:
\nAlter Table test noParallel; \/\/\u5173\u95ed\u5e76\u53d1
\nAlter Table test LOGGING; \/\/\u6253\u5f00\u64cd\u4f5c\u65e5\u5fd7<\/p>\n
\nselect \/<\/em>+ INDEX(test,test_username)\/ <\/em> from test where username ='test_5000094';<\/p>\n
\nALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE;<\/p>\n
\nselect \/+INDEX(test,test_change)<\/em>\/count(*) from test where CHANGEDATE>to_date('2014-09-28 09:38:11','yyyy-mm-dd hh24:mi:ss') and CHANGEDATE<to_date('2014-09-28 09:38:13','yyyy-mm-dd hh24:mi:ss');<\/p>\n
\nALTER INDEX test_username REBUILD ONLINE;<\/p>\n
\n:
\nanalyze table test estimate statistics;--\u62bd\u6837\u5206\u6790\uff0c\u6bd4\u8f83\u5feb\uff0c\u63a8\u8350<\/p>\n
\nANALYZE TABLE \u8868\u540d COMPUTE STATISTICS FOR ALL INDEXED COLUMNS;
\n\u51fd\u6570\u7d22\u5f15\u53ef\u4e34\u65f6\u751f\u6548,\u751f\u6548
\nALTER INDEX indexname DISABLE | ENABLE; <\/p>\n
\nALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE;
\n--do something here
\nALTER INDEX indexname REBUILD ONLINE;<\/p>\n
\n`<\/p>\n","protected":false},"excerpt":{"rendered":"