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

oracleµÄ±íµÄÖÖÀà

±íÀàÐÍ£º
1¶Ñ×éÖ¯±í£¨heap organized table£©£ºÕâЩ¾ÍÊÇ“ÆÕͨ”µÄ±ê×¼Êý¾Ý¿â±í¡£Êý¾ÝÒԶѵķ½Ê½¹ÜÀí¡£¶Ñ£¨heap£©ÊÇÒ»×é¿Õ¼ä£¬ÒÔÒ»ÖÖÓÐЩËæ»úµÄ·½Ê½Ê¹Óá£
2Ë÷Òý×éÖ¯±í£¨index organized table£©£ºÕâЩ±í°´Ë÷Òý½á¹¹´æ´¢¡£Õâ¾ÍÇ¿ÖÆÒªÇóÐб¾ÉíÓÐijÖÖÎïÀí˳Ðò¡£Ë÷Òý×éÖ¯±íIOTÖУ¬Êý¾ÝÒª¸ù¾ÝÖ÷¼üÓÐÐòµØ´æ´¢¡£
3Ë÷Òý¾Û´Ø±í£¨index clustered table£©£º¾Û´Ø£¨cluster£©ÊÇÖ¸Ò»¸ö»ò¶à¸ö±í×é³ÉµÄ×飬ÕâЩ±íÎïÀíµØ´æ´¢ÔÚÏàͬµÄÊý¾Ý¿â¿éÉÏ£¬ÓÐÏàͬ¾Û´Ø¼üÖµµÄËùÓÐÐлáÏàÁÚµØÎïÀí´æ´¢¡£
    ÕâÖֽṹ¿ÉÒÔʵÏÖÁ½¸öÄ¿±ê¡£
    Ê×ÏÈ£¬¶à¸ö±í¿ÉÒÔÎïÀíµØ´æ´¢ÔÚÒ»Æð¡£Ò»°ã¶øÑÔ£¬Äã¿ÉÄÜÈÏΪһ¸ö±íµÄÊý¾Ý¾ÍÔÚÒ»¸öÊý¾Ý¿â¿éÉÏ£¬µ«ÊǶÔÓÚ¾Û´Ø±í£¬¿ÉÄܰѶà¸ö±íµÄÊý¾Ý´æ´¢ÔÚͬһ¸ö¿éÉÏ¡£
    Æä´Î£¬°üº¬Ïàͬ¾Û´Ø¼üÖµ£¨ÈçDEPTNO=10£©µÄËùÓÐÊý¾Ý»áÎïÀíµØ´æ´¢ÔÚÒ»Æð¡£ÕâЩÊý¾Ý°´¾Û´Ø¼üÖµ“¾Û´Ø”ÔÚÒ»Æ𡣾۴ؼüʹÓÃB*Ê÷Ë÷Òý½¨Á¢¡£
4É¢ÁÐ¾Û´Ø±í£¨hash clustered table£©£ºÕâЩ±íÀàËÆÓÚ¾Û´Ø±í£¬µ«ÊDz»Ê¹ÓÃB*Ê÷Ë÷Òý¾Û´Ø¼üÀ´¶¨Î»Êý¾Ý£¬É¢Áо۴ؽ«¼üÉ¢Áе½¾Û´ØÉÏ£¬´Ó¶øÕÒµ½Êý¾ÝÓ¦¸ÃÔÚÄĸöÊý¾Ý¿â¿éÉÏ¡£
    ÔÚÉ¢Áо۴ØÖУ¬Êý¾Ý¾ÍÊÇË÷Òý£¨ÕâÊÇÒþÓ÷µÄ˵·¨£©¡£Èç¹ûÐèҪƵ·±µØͨ¹ý¼üµÄÏàµÈÐԱȽÏÀ´¶ÁÈ¡Êý¾Ý£¬É¢Áо۴رí¾ÍºÜÊÊÓá£
5ÓÐÐòÉ¢ÁÐ¾Û´Ø±í£¨sorted hash clustered table£©£ºÕâÖÖ±íÀàÐÍÊÇOracle 10gÖÐÐÂÔöµÄ£¬Ëü½áºÏÁËÉ¢Áо۴رíµÄijЩ·½Ã棬ͬʱ¼æÓÐIOTµÄһЩ·½Ãæ¡£
    ÄãµÄÐа´Ä³¸ö¼üÖµ£¨ÈçCUSTOMER_ID£©É¢ÁУ¬¶øÓë¸Ã¼üÏà¹ØµÄһϵÁмǼÒÔijÖÖÓÐÐò˳Ðòµ½´ï£¨Òò´ËÕâЩ¼Ç¼ÊÇ»ùÓÚʱ¼ä´ÁµÄ¼Ç¼£©£¬²¢°´ÕâÖÖÓÐÐò˳Ðò´¦Àí¡£
    ÀýÈ磬¿Í»§ÔÚÄãµÄ¶©µ¥ÊäÈëϵͳÖÐ϶©µ¥£¬ÕâЩ¶©µ¥»á°´ÏȽøÏȳö£¨first in, first out, FIFO£©µÄ·½Ê½»ñÈ¡ºÍ´¦Àí¡£ÔÚÕâÑùÒ»¸öϵͳÖУ¬ÓÐÐòÉ¢Áо۴ؾÍÊÇÊÊÓõÄÊý¾Ý½á¹¹¡£
6ǶÌ×±í£¨nested table£©£ºÇ¶Ì×±íÊÇOracle¶ÔÏó¹ØϵÀ©Õ¹µÄÒ»²¿·Ö¡£ËüÃÇʵ¼ÊÉϾÍÊÇϵͳÉú³ÉºÍά»¤µÄ¸¸/×Ó¹ØϵÖеÄ×Ó±í¡£
    ǶÌ×±íÓë×Ó±íµÄÖ÷ÒªÇø±ðÊÇ£ºÇ¶Ì×±í²»Ïñ×Ó±í£¨ÈçEMP£©ÄÇÑùÊÇ“¶ÀÁ¢”±í¡£
7ÁÙʱ±í£¨temporary table£©£ºÕâЩ±í´æ´¢µÄÊÇÊÂÎñÆÚ¼ä»ò»á»°ÆÚ¼äµÄ“²Ý¸å”Êý¾Ý¡£
    ÁÙʱ±íÒª¸ù¾ÝÐèÒª´Óµ±Ç°Óû§µÄÁÙʱ±í¿Õ¼ä·ÖÅäÁÙʱÇø¶Î¡£Ã¿¸ö»á»°Ö»ÄÜ¿´µ½Õâ¸ö»á»°·ÖÅäµÄÇø¶Î£»Ëü´Ó²»»á¿´µ½ÆäËûÈκλá»


Ïà¹ØÎĵµ£º

±±´óÇàÄñoracleѧϰ±Ê¼Ç12


¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥); ......

Oracle±í¹ÜÀí_3ÔÂ6ÈÕ

3ÔÂ6ÈÕ£º
¾Å¡¢±í¹ÜÀí£º
Ò»¡¢ÔÙ±í¹ÜÀíÖÐÐèҪѧϰµÄÄÚÈÝ£º
1¡¢  ´´½¨±í
2¡¢  ³£ÓõÄÊý¾ÝÀàÐÍ
3¡¢  ɾ³ý±í
4¡¢  ¸´ÖƱí
5¡¢  Ð޸ıí
6¡¢  ±íÖØÃüÃû
7¡¢  ½Ø¶Ï±í
8¡¢  ±íµÄÔ¼ÊøÌõ¼þ
¶þ¡¢´´½¨±í
³£¼û±íÓï·¨£º
´´½¨±íÓï·¨£º
CREATE TABLE ±íÃû
(
   &nb ......

´óÐÍORACLEÊý¾Ý¿âÓÅ»¯Éè¼Æ·½°¸

±¾ÎÄÖ÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó¾Å¸ö²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáÁËORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
    ¹Ø¼ü´Ê ORACLEÊý¾Ý¿â»·¾³µ÷ÕûÓÅ»¯Éè¼Æ·½°¸
    ¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ÏµÍ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç13

ǶÌ×±í£º
Óë¿É±äÊý×éÀàËÆ£¬²»Í¬Ö®´¦ÊÇǶÌ×±íûÓÐÊý¾ÝÉÏÏÞ¡£
Óï·¨£º
´´½¨»ùÀàÐÍ
create or replace type ǶÌ×±í»ùÀàÐÍÃû as object(×ֶβÎÊý);
create or replace type mingxitype as object(
goodsid varchar(15),
incount int,
providerid varchar(10)
)not final;
´´½¨Ç¶Ì×±íÀàÐÍ
create or replace type Ç ......

ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ


²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 Î´ÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
 
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ¢£¬
IOPS£º66
¶ÁÈ¡£º90MB/s
дÈ룺82MB/s
 
² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ