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£©£ºÕâЩ±í´æ´¢µÄÊÇÊÂÎñÆÚ¼ä»ò»á»°ÆÚ¼äµÄ“²Ý¸å”Êý¾Ý¡£
ÁÙʱ±íÒª¸ù¾ÝÐèÒª´Óµ±Ç°Óû§µÄÁÙʱ±í¿Õ¼ä·ÖÅäÁÙʱÇø¶Î¡£Ã¿¸ö»á»°Ö»ÄÜ¿´µ½Õâ¸ö»á»°·ÖÅäµÄÇø¶Î£»Ëü´Ó²»»á¿´µ½ÆäËûÈκλá»
Ïà¹ØÎĵµ£º
´Ø£º
Óй«¹²ÁеÄÁ½¸ö»ò¶à¸ö±íµÄ¼¯ºÏ
´Ø±íÖеÄÊý¾Ý´æ´¢ÔÚ¹«¹²Êý¾Ý¿éÖÐ
´Ø¼ü£º
Ψһ±êʶ·û
´´½¨´Ø£º
¼õÉÙI/O²Ù×÷£¬¼õÉÙ´ÅÅ̿ռ䣬µ«ÊDzåÈëÐÔÄܽµµÍ¡£
Á½ÕűíÖÐÓй²Í¬µÄÁУ¬±ÈÈçѧÉú±íÖÐÓа༶±àºÅ£¬°à¼¶±íÖÐÒ²Óа༶±àºÅ£¬¿ÉÒÔ½«°à¼¶±àºÅ´æ·ÅÔÚ´ØÖÐ
create cluster ´ØÃû(
×Ö¶ÎÃû ÀàÐÍ
)tablespace ±íÃüÃû¿Õ¼ä;
cr ......
¹ØϵÐÍÊý¾Ý¿âÀíÂÛÖÐ×Ö¶ÎÖµ±ØÐëÊǵ¥Öµ£¬¶øoracleÖÐÔÊÐíÔÚÒ»¸ö×Ö¶ÎÖд洢һ¸ö±íµÄÄÚÈÝ¡£
È磺Ա¹¤±íÖеÄÍâ¼ü ²¿ÃűàºÅ£¬oracleÖÐÕâ¸ö×ֶοÉÒÔ´æ·Å²¿ÃŵļǼ¶ø²¢²»ÊÇÒ»¸öÍâ¼ü£¬ÕâÑù²éѯʱºòµÄЧÂÊ»áÌá¸ß¡£
¿É±äÊý×飺
´´½¨´øÓпɱäÊý×éµÄ±í
´´½¨¿É±äÊý×é»ùÀàÐÍ
create or replace type »ùÀàÐÍÃû as object(×Ö¶ÎÇåµ¥);
......
MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
ID
INTEGER ......
1z0-047 ×ÊÁϵÄ×îзÖÏí£¬ÏÂÃæһЩÌâÄ¿ÊÇ´Ó×îеÄÌâ¿âÖо«ÐÄÕûÀí³öÀ´µÄ£¬ÖÊÁ¿ºÜ¸ß£¬ÐèÒªµÄÅóÓÑ¿´¹ýÀ´µÄ°¡¡£
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictiona ......
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
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
² ......