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

ORACLEÎﻯÊÓͼ ¸ßËÙ¸ßЧ ´´½¨ÎﻯÊÓͼÌá¸ß²éѯËÙ¶È


ÄãÊÇ·ñΪµÈ´ýÄãµÄ²éѯ·µ»Ø½á¹û¶ø¸Ðµ½Æ£±¹£¿ÄãÊÇ·ñÒѾ­ÎªÔöÇ¿Ë÷ÒýºÍµ÷ÓÅSQL¶ø¸Ðµ½Æ£±¹£¬µ«ÈÔÈ»²»ÄÜÌá¸ß²éѯÐÔÄÜ£¿ÄÇô£¬ÄãÊÇ·ñÒѾ­¿¼ÂÇ´´½¨ÎﻯÊÓͼ£¿ÓÐÁËÎﻯÊÓͼ£¬ÄÇЩ¹ýÈ¥ÐèÒªÊýСʱÔËÐеı¨¸æ¿ÉÒÔÔÚ¼¸·ÖÖÓÄÚÍê³É¡£ÎﻯÊÓͼ¿ÉÒÔ°üÀ¨Áª½Ó£¨join£©ºÍ¼¯ºÏ£¨aggregate£©
ÄãÊÇ·ñΪµÈ´ýÄãµÄ²éѯ·µ»Ø½á¹û¶ø¸Ðµ½Æ£±¹£¿ÄãÊÇ·ñÒѾ­ÎªÔöÇ¿Ë÷ÒýºÍµ÷ÓÅSQL¶ø¸Ðµ½Æ£±¹£¬µ«ÈÔÈ»²»ÄÜÌá¸ß²éѯÐÔÄÜ£¿ÄÇô£¬ÄãÊÇ·ñÒѾ­¿¼ÂÇ´´½¨ÎﻯÊÓͼ£¿ÓÐÁËÎﻯÊÓͼ£¬ÄÇЩ¹ýÈ¥ÐèÒªÊýСʱÔËÐеı¨¸æ¿ÉÒÔÔÚ¼¸·ÖÖÓÄÚÍê³É¡£ÎﻯÊÓͼ¿ÉÒÔ°üÀ¨Áª½Ó£¨join£©ºÍ¼¯ºÏ£¨aggregate£©£¬ËüÌṩÁËÒ»ÖÖ´¢´æÔ¤¼ÆËã½á¹ûµÄ·½·¨¡£
ÔÚÖ´ÐÐÒ»¸ö²éѯʱ£¬ÓÅ»¯Æ÷»áÅж¨·ÃÎÊÎﻯÊÓͼ»òÊý¾ÝפÁôµÄ»ù´¡±íÊÇ·ñ¸ü¿ìһЩ¡£Èç¹ûÓÅ»¯Æ÷Åж¨²éѯÎﻯÊÓͼÊǸüºÃµÄ½â¾ö·½°¸£¬ÄÇôÓÅ»¯Æ÷»áÔÚÒ»¸ö±»³ÆÎª“²éѯ¸Äд”£¨query rewrite£©µÄ¹ý³ÌÖиÄдSQL²éѯ¡£ÔÚÕâ¸ö¹ý³ÌÖУ¬²»ÐèÒª¶ÔÈκÎSQL»òÓ¦ÓóÌÐò´úÂë½øÐÐÐ޸ģ¬ËùÒÔÈκÎÀûÓÃSQL·ÃÎÊÊý¾Ý¿âµÄÓ¦ÓóÌÐò»òÌØ¶¨²éѯ¹¤¾ß¶¼¿ÉµÃÒæÓÚʹÓÃÎﻯÊÓͼ¡£µ±Îª¼ÆËã½á¹û¶øÐèÒª·ÃÎʵÄÊý¾ÝÊýÁ¿Ô¶´óÓÚ½á¹û£¨È缯ºÏ£©µÄ´óСʱ£¬×îÊʺÏʹÓòéѯ¸Äд£¬µ«ÊÇËüÒ²¿É±»ÓÃÓÚ¼ÓËÙ°º¹óµÄÁª½Ó»ò¹æ»®¡£
±¾ÎÄÊ×ÏȽéÉÜÁËÓÅ»¯Æ÷¿ÉÒÔÖ´ÐеIJéѯ¸ÄдÀàÐÍ¡£È»ºó£¬ËüÌÖÂÛÁ˰ïÖúÈ·¶¨´´½¨×î¼ÑÎﻯÊÓͼ¼¯µÄ¹¤¾ß£¬Ê¹ÓÅ»¯Æ÷Äܹ»¸Äд¶à¸ö²éѯ¡£ÀûÓÃÕâЩ¹¤¾ß´´½¨µÄÎﻯÊÓͼÔÚÆä»ù´¡Êý¾Ý·¢Éú±ä»¯Ê±»¹¿ÉÒÔ¿ìËÙˢС£Èç¹ûÄã²»ÖªµÀ´´½¨Ò»¸öÎﻯÊÓͼ¡¢Ò»¸öË÷Òý»òͬʱ´´½¨Á½ÕßÄÄÖÖ¸üºÃ£¬ÄÇôÔÚOracleÊý¾Ý¿â10gÖÐÒýÈëµÄSQL Access Advisor¿ÉÒÔͨ¹ý·ÖÎö¸ø¶¨µÄ¹¤×÷¸ººÉ°ïÖúÄã×ö³ö¾ö¶¨¡£
²éѯ¸ÄдÀàÐÍ
¿ÉÄÜÓÐÐí¶àÀàÐ͵IJéѯ¸Äд£»µ±ÎﻯÊÓͼµÄ¶¨Òå²éѯÓë²éѯµÄÎı¾ÍêȫƥÅäʱ£¬¾Í·¢Éú×î¼òµ¥ºÍ×îÏÔÖøÀàÐ͵IJéѯ¸Äд¡£µ«ÊÇ£¬µ±ÏàͬÎﻯÊÓͼ¿ÉÓÃÓÚÏàÓ¦¶à¸ö²éѯʱ£¬¾Í¿ÉÒÔʵÏÖ²éѯ¸ÄдµÄ×î´óºÃ´¦¡£ÏÖÔÚ£¬ÎÒÃǽ«¾ÙÀý˵Ã÷һЩOracleÓÅ»¯Æ÷ʹÓõĹæÔò£¬ÒÔÈ·¶¨ËüÊÇ·ñ½«Ê¹ÓÃÎﻯÊÓͼÀ´ÏìÓ¦¡£
¶ÔÓÚ±¾ÎÄÖеÄʾÀý£¬¿ÉÒÔ¿¼Âǽ«Ò»¸öÐÇÐÎģʽÖеÄPURCHASES±í¿´×÷ÊÂʵ±í£¨fact table£©£¬Æä·¶Î§ÓÉtime_key»®·Ö¡£Î¬¶È±í£¨dimension table£©--TIME¡¢PRODUCTºÍCUSTOMERS--°üº¬Ö÷¼ü time_key¡¢product_idºÍcust_id¡£ÔÚPURCHASES±íÖÐÓÐÒýÓø÷¸öά¶È±íµÄÍâ¼üÔ¼Êø¡£
¿¼ÂÇÒ»ÏÂÇåµ¥ 1ÖÐËù´´½¨µÄÎﻯÊÓͼ£¬¸ÃÊÓͼ°´Ô°´product_id¼ÆËãÏúÊÛ×ܶîºÍÏúÊÛ×Ü´ÎÊý¡£×¢Ò⣺¶ÔÓÚÓÃÓÚ²éѯ¸ÄдµÄÎﻯÊÓͼ£¬±ØÐëÓÐENABLE QUERY REWRITE×Ӿ䡣»¹ÓУ¬³õʼ»¯


Ïà¹ØÎĵµ£º

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


   ÔÚOracleµÄQuery RewriteÖÐÖ÷ÒªÓÐÈýµã, µÚÒ»ÊÇҪʹÓÃCBO; µÚ¶þÊÇÒªÉèÖÃquery rewrite enabled²ÎÊýΪTRUE; µÚÈýÊÇÒªÏÈÔñÉèÖÃquery rewrite integrity²ÎÊýµÄÖµ(stale_tolerated, trusted, enforced). ¶ÔÓÚµÚÒ»µã, ÎÒÃÇ×îºÃanalyzeÏà¹ØµÄ±í¼°Ë÷Òý¼°MV; ¶ÔÓÚµÚ¶þµã,Õâ¸ö²ÎÊýÖ»ÓÐÁ½¸öÖµ(true, false), ºÜ¼òµ ......

oracle ±¸·ÝÃüÁî

µ¼³ö EXP USER/PASSWORD@ODBC FILE=C£º\***.DMP ROWS=N //²»±£´æÊý¾Ý£»
µ¼³ö EXP USER/PASSWORD@ODBC FILE=C£º\***.DMP   //±£´æÊý¾Ý£»
µ¼³ö EXP USER/PASSWORD@ODBC FILE=C£º\***.DMP full=y //È«²¿µ¼³ö£»
µ¼Èë imp user/password@odbc file=c:\***.dmp full=y ignore=y;
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏà ......

OracleÊý¾Ý¿â±í¿Õ¼ä²Ù×÷

// ½¨Á¢±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
create TABLESPACE EAS_D_sptcc0_STANDARD DATAFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD.dbf' size 10000M EXTENT MANAGEMENT local;
// ɾ³ý±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
DROP TABLESPACE temp_data INCLUDING CONTENTS AND DATAFILES;
// ½¨Á¢ÁÙʱ±í¿Õ¼ä¡£
CREATE TEMPORARY TABLESPA ......

linux oracle °²×°

linuxÏÂoracle°²×°£º
Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶     
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£     
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9 ......

oracleÏòmysqlÒÆÖ²

ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËÆµÄ¶«Î÷À´×ö,ÈçÏ£º  
  create   table   myseq   ( &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ