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

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

http://www.anysql.net/oracle/query_rewrite_01.html
  Query Rewrite ÔÚÊý¾Ý²Ö¿âÊÇÊÇÒ»¸ö·Ç³£ÓÐÓõļ¼Êõ, TomÔÚ<<Effective Oracle by Design>>Ò»ÊéÖн«ÊµÌ廯ÊÓͼ(MView)³ÆÎªÊÇÊý¾Ý²Ö¿âµÄË÷Òý, ÕâÊÇÔÙÌùÇв»¹ýµÄÁË, ÔÚOLTPÖе±SELECTÓï¾äµÄËùÓеÄ×ֶζ¼ÔÚË÷ÒýÖÐʱ, Oracle¿ÉÒÔ²»´Ó±í¶ÁÊý¾Ý, ¶øÖ±½Ó´ÓË÷ÒýÖлñµÃÈ«²¿ÐÅÏ¢, ¶øQuery RewriteÔòÊÇͨ¹ý´´½¨Öмä±í, ÈÃOracle×Ô¶¯´Ó´´½¨µÄÖмä±í¶ÁÈ¡Êý¾Ý, ¶ø²»ÐèÒª´ÓÔ­±í¶ÁÈ¡ÁË, Õâ¸öÖмä±í¿ÉÒÔÊÇÔ¤ÏÈjoinºÃµÄ»òÔ¤ÏȼÆËãºÃµÄÖмä½á¹û. ËûµÄʹÓþͺÍÒ»°ãµÄË÷ÒýͬÀíÁË, ËäÈ»ÄãÖ¸¶¨µÄ»¹ÊÇÄǸö´ó±í, µ«oracle¿ÉÒÔΪÄã×Ô¶¯Ê¶±ð¿ÉÒÔ´ÓÄǸö"Êý¾Ý²Ö¿âË÷Òý"ÖжÁÈ¡Êý¾Ý. ÏÂÃæÎÒÃÇ¿ÉÒÔÀ´¿´Ò»ÏÂ×î¼òµ¥µÄÀý×Ó:
SQL> CREATE TABLE DETAIL_TABLE                                     
  2  AS SELECT OWNER,OBJECT_NAME from sys.dba_objects; 
Table created.
SQL> DESC DETAIL_TABLE
 Name                               Null?    Type 
 ---------------------------------- -------- --------------
 OWNER                                       VARCHAR2(30)
 OBJECT_NAME                                 VARCHAR2(128)
SQL> CREATE MATERIALIZED VIEW MID_TABLE ENABLE QUERY REWRITE
  2  AS
  3  SELECT OWNER,COUNT(*) TABCNT from DETAIL_TABLE GROUP BY OWNER;
Materialized view created.
SQL> DESC MID_TABLE
 Name  


Ïà¹ØÎĵµ£º

oracle´ó¶ÔÏó

ÔÚµ±½ñÍøÂçʱ´ú£¬ÎÒÃǶÔÊý¾ÝµÄ´æ´¢ÊÇÔ½À´Ô½¸ß£¬½ö½ö´æ´¢Ð¡ÐÍÎı¾Êý¾ÝÒѾ­Ô¶Ô¶²»¹»ÁË£¬ÏÖÔÚÊý¾Ý¿âÐèÒª´æ´¢Í¼Æ¬¡¢ÊÓÆµµÈµÈһЩ¶àýÌåµÄÄÚÈÝ£¬Òò´Ëoracle¸øÎÒÃÇÌṩÁËÒ»ÖÖ´óÀàÐÍÊý¾Ý¿â¶ÔÏóLOB(Large Object),¿ÉÒÔÓÃÓÚ´æ´¢´óÐÍÊý¾Ý¡£
Ò»¡¢´ó¶ÔÏóµÄ4ÖÐÊý¾ÝÀàÐÍ
CLOB       ×Ö·ûLOBÊý¾ÝÀàÐÍ£¬ÓÃÓ ......

oracleÖÐ×Ö·û´®£¨Õª³­£©

¹ØÓÚOracleÖÐ×Ö·û´®µÄ˵Ã÷
×Ö·û´®
OracleÖÐÓÐËÄÖÖ»ù±¾µÄ×Ö·û´®ÀàÐÍ,·Ö±ðÊÇchar¡¢varchar2¡¢ncharºÍnvarchar2¡£ÔÚOracleÖУ¬ËùÓд®¶¼ÒÔͬÑùµÄ¸ñʽ´æ´¢¡£ÔÚÊý¾Ý¿éÓÐÒ»¸ö1~3×ֽڵij¤¶È×ֶΣ¬Æäºó²ÅÊÇÊý¾Ý£¬Èç¹ûÊý¾ÝλNULL£¬³¤¶È×Ö¶ÎÔò±íʾΪһ¸öµ¥×Ö½ÚÖµ0xFF.
Èç¹û´®µÄ³¤¶ÈСÓÚ»òµÈÓÚ250£¨0x01~0xFA),Oracle»áʹÓÃ1¸ö×Ö½ÚÀ´ ......

Oracle9ÖÐXML SQL Utility¼¼ÊõÖ¸µ¼(java)

¡ö     ¿ª·¢Ç°ÒªÇóÅäÖÃ
¡ö     Select XML¸ñʽÊý¾Ý
¡ö     Insert XML¸ñʽÊý¾Ý
¡ö     Updata XML¸ñʽÊý¾Ý
¡ö     Delete XML¸ñʽÊý¾Ý
¿ª·¢Ç°ÒªÇóÅäÖÃ
±ØÐë°²×°Oracle¿Í»§¶Ë
°ÑClasspathÖ¸Ïò
classes111.zip ......

±ØÐëÒýÆðDBAÖØÊÓµÄOracleÊý¾Ý¿âË鯬

À´Ô´£º[url]http://www.wangchao.net.cn/bbsdetail_1788053.html[/url]
Ŀǰ£¬OracleÒѾ­¹ã·ºµÄÓ¦ÓÃÓÚ¸÷¸öÐÐÒµ¡£×÷ΪһÃûDBA£¬¼°Ê±·¢ÏÖ²¢ÕûÀíË鯬ÒѾ­³ÉΪDBAÈÕ³£¹¤×÷ÖеÄÒ»ÏîÖØÒªÎ¬»¤ÄÚÈÝ¡£ 1¡¢Ë鯬ÊÇÈçºÎ²úÉúµÄ µ±Éú³ÉÒ»¸öÊý¾Ý¿âʱ£¬Ëü»á·Ö³É³ÆÎª±í¿Õ¼ä(tablespace)µÄ¶à¸öÂß¼­¶Î(segment)£¬Èçϵͳ(system)±í¿Õ¼ä,ÁÙʱ(te ......

oracleÕýÔò±í´ïʽ

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ
Ŀǰ£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Orac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ