Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLEÎﻯÊÓͼ Query RewriteµÄÒ»°ãÀí½âÖ®ËÄ


   ¿ÉÒÔ¿´µ½MVIEWÔÚQuery RewriteÖеÄÖØÒªÐÔ, ÒªÔÚʵ¼ÊÓ¦ÓÃÖÐʹÓÃ, ¾ÍµÃÖªµÀËüµÄºÜ¶à·½Ãæ, ÆäÖÐË¢ÐÂÊÇ×îÖ÷ÒªµÄ:
1, MVIEWÈÕÖ¾µÄ½¨Á¢
2, »ã×ÜÐ͵ÄMIVEWµÄË¢ÐÂ
3, JOINÀàÐ͵ÄMVIEWµÄË¢ÐÂ
4, ¸ü¸´ÔÓµÄMVIEWµÄË¢ÐÂ
5, ·ÖÇøÊ±µÄMVIEWµÄË¢ÐÂ
   ÔÚÕâ¶ùÎÒÃÇÖ÷ÒªÌÖÂÛµÄÊÇÈçºÎʵÏÖFastË¢ÐÂ, ·ñÔòûÓжàÉÙÒâÒéµÄ. ÎÒÃÇÒ»µãÒ»µãÀ´¿´:
   1, ҪʵÏÖÔöÁ¿Ë¢ÐÂ, ±ØÐëÔÚMVIEWÒýµÄµÄ±íÉÏ´´½¨MVIEW Log, ÎÒÃÇÖ÷ÒªÀ´ËµÒ»Ï¼¸¸öÑ¡Ïî
WITH ROWID/PRIMARY KEY : ÔÚMVIEW LogÖмǼROWID»òÖ÷¼üÒÔ·´Ó³¸Ä¸ü¹ýµÄ¼Ç¼, ¶ÔÓÚÒ»°ã±íÎÒÍÆ¼öÓÃWITH ROWID, ¶ÔÓÚIOT, ÔòÇëÓÃPRIMARY KEY.
(column list): ΪÁËÈÃMVIEW LOG±äµÃСһµãÄã¿ÉÒÔÖ»°üÀ¨½øÔÚMVIEWµÄSQLÖÐÒýÓõÄ×Ö¶Î, OracleÓñíÀ´ÊµÏÖMVIEW LOGÔÚ¸üÐÂÆµ·±µÄ±íÉÏ, MVIEW LOG¿ÉÄÜ»á±äµÃºÜ´ó. ÔÚÖ¸¶¨ÁËWITH PRIMARY KEYʱ, Ö÷¼üµÄÁÐÒѾ­°üÀ¨ÁË, Òò´ËÔÚcolumn listÖоͲ»ÒªÔÙд½øÈ¥ÁË.
WITH SEQUENCE: ÓÃÓڼǼÐ޸ķ¢ÉúµÄ˳Ðò, Èç¹ûûÓжԻù±íµÄDELETE²Ù×÷Ôò¿ÉÒÔ²»ÓüÓÕâ¸öÑ¡Ïî.
INCLUDING NEW VALUES: Ö÷ÒªÓÃÓÚÔÚ»ã×ÜÐ͵ÄMVIEWʱ, ͬʱ¼Ç¼×ֶεľÉÖµºÍÐÂÖµÒÔʵÏÖ¿ìËÙË¢ÐÂ, ĬÈÏÊÇEXCLUDING NEW VALUES, ÕâʱÈçÐèÒªµ±Ç°Öµ, OracleÐèÒªµ½±íÖÐÈ¥²éѯ.
   2, »ã×ÜÐ͵ÄMIVEWµÄË¢ÐÂ, OracleÖ§³Ö·Ö×麯Êý¼°Ò»²¿·ÝµÄ·ÖÎöº¯ÊýµÄÔöÁ¿Ë¢ÐÂ.
½«count(*)¼Óµ½MVIEWµÄSQL, Èç¹ûÓÐSUM(*)ºÍCOUNT(*)´æÔھͿÉÒÔʵÏÖÔöÁ¿Ë¢ÐÂ.
  3, JOINÀàÐ͵ÄMVIEWµÄË¢ÐÂ
ÔÚJoinµÄMVIEWʱ½«»ù±íµÄROWID¶¼¼Óµ½MVIEWÖÐ, ÈçTA(A,B)ºÍTB(C,D), ÔòMVIEWʱ¿ÉÒÔдΪ, SELECT TA.ROWID TA_ROWID,TB.ROWID TB_ROWID, <<collist>> from TA,TB WHERE ...
  4, ¸´ÔÓÀàÐ͵ÄMVIEWµÄË¢ÐÂ
¿ÉÒÔ¿¼ÂÇת»»³É¼¶ÁªµÄMVIEW, ÈçÏȽ¨JOINµÄMVIEW, ÔÙ½¨SUMMARYµÄMVIEW
  5, ·ÖÇøÊ±µÄMVIEWµÄË¢ÐÂ
ÓÃDBMS_MVIEW.MARKER(±íÃû)À´»ñµÃ·ÖÇøID, ²¢¼Óµ½MIVEWµÄSELECTÁбíÖÐ, ÕâÑù¿ÉÒÔʵÏÖ·ÖÇø±íµÄÔöÁ¿Ë¢ÐÂ, Çë×ÔÒÑ×öʵÑéÀ´²âÊÔ.
   ¹ØÓÚÕⲿ·ÝµÄ½âÊÍ, ÔÚ<<Data Warehouse Guide>>ÕâÒ»¸öÎĵµÖÐÓкÜÏêϸµÄ½âÉÜ, ÎÒÒ²ÕýÔÚ¿´, ¿´Íêºó»á¸üеÄ.


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle±Ê¼Ç


sqlplus sys/password  as sysdba;ϵͳ¹ÜÀíÔ±µÇ¼
alter user scott account unlock; ¸ü¸ÄÓû§
desc £¨±íÃû£©
select * from (table name);
select distinct ename from emp;
select ename,sal from emp;
select ename,sal*12 'annual_sal' from emp;
select ename,sal from emp where sal>1000;
select ......

1 oracle ʵÀý

1 oracle ʵÀý
°²×°--È«¾ÖÊý¾Ý¿âÃû£º¿ÉÒÔ¼ÓÀ©Õ¹Ãû£º±ÈÈçtest.com.cn£¨¶øÊý¾Ý¿âʵÀýÃûΪtest£©
Êý¾Ý¿â¿ÚÁî:ΪÊý¾Ý¿âϵͳÕÊ»§£ºsys,system,sysman,dbsnmpÌṩÃÜÂë
¸ß¼¶°²×°£ºÎªÃ¿¸öÓû§Ìṩ²»Í¬µÄÃÜÂë
sys: change_on_install
system:manager
sysman:oem_temp
dbsnmp:dbsnmp
internal: orcale
scott:tiger
demo: ......

ORACLEÎﻯÊÓͼ ÎﻯÊÓͼÈÕÖ¾½á¹¹

http://space.itpub.net/4227/viewspace-68592
ÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂÒªÇó»ù±¾±ØÐ뽨Á¢ÎﻯÊÓͼÈÕÖ¾£¬ÕâÆªÎÄÕ¼òµ¥ÃèÊöÒ»ÏÂÎﻯÊÓͼÈÕÖ¾Öи÷¸ö×ֶεĺ¬ÒåºÍÓÃ;¡£
 
ÎﻯÊÓͼÈÕÖ¾µÄÃû³ÆÎªMLOG$_ºóÃæ¸ú»ù±íµÄÃû³Æ£¬Èç¹û±íÃûµÄ³¤¶È³¬¹ý20룬Ôòֻȡǰ20룬µ±½Ø¶Ìºó³öÏÖÃû³ÆÖظ´Ê±£¬Oracle»á×Ô¶¯ÔÚÎﻯÊÓͼÈÕÖ¾Ãû³ÆºóÃæ¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ