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

ORACLE Êý¾Ý¿â¶ÔÏó

ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
 
q      Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q      ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q      ¼õÉÙ´ÅÅÌI/O
q      ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q      ÔÚÂß¼­ÉϺÍÎïÀíÉ϶¼¶ÀÁ¢ÓÚ±íµÄÊý¾Ý
q      Oracle ×Ô¶¯Î¬»¤Ë÷Òý
 
Ë÷ÒýµÄÄ¿±ê£ºÌá¸ß²éѯÐÔÄÜ
 
Ë÷Òý¶ÔÔöɾ¸Ä²éµÄÓ°Ïì
SQLÓï¾ä
¶ÔÐÔÄܵÄÓ°Ïì
SELECT
²éѯÐÔÄÜÌá¸ß
UPDATE
¸üÐÂɾ³ýʱÐèÒªÏȲéѯ£¬´Ó´Ë½Ç¶ÈÐÔÄÜÌá¸ß
¸üÐÂɾ³ýʱÒýÆðË÷ÒýÐ޸ģ¬´Ó´Ë½Ç¶ÈÐÔÄÜϽµ
DELETE
INSERT
Ôö¼ÓÒýÆðË÷Òý¸Ä±ä£¬Ë÷Òý¶ÔÆä¸ºÃæÓ°Ïì¸ü´ó£¬ÐÔÄÜϽµ
 
ʲôʱºò½¨Á¢Ë÷Òý£¿
1.         ÐèҪƵ·±²éѯµÄÊý¾Ý
2.         Êý¾ÝÁ¿½Ï¶à
3.         ¸ÃÁв»»áƵ·± update/insert/delete
4.         ÔÚ where/order by/group by ×Ö¾äÖгöÏÖµÄÁÐ
5.         Ôڸ߻ùÊýÁÐÉϽ¨Á¢Ë÷Òý£¨Öظ´Êý¾Ý²»¶à£©
empno
ename
sal
1
HUANGPei
1000
1
HUANGPei
1000
3
HUANGPei
1000
4
HUANGPei
1000
 
empno
ename
sal
1
HUANGPei
1000
1
HUANGPei
1000
1
HUANGPei
1000
1
HUANGPei
1000
»ùÊý£º3/4
»ùÊý£º1/4
 
Ë÷ÒýµÄÀàÐÍ
ΨһË÷Òý
λͼË÷Òý
×éºÏË÷Òý
»ùÓÚº¯ÊýµÄË÷Òý
·´Ïò¼üË÷Òý
´´½¨±ê×¼Ë÷Òý
 
CREATE INDEX item_index ON itemfile (itemcode)
     TABLESPACE index_tbs;
 
ÖØ½¨Ë÷Òý
 
ALTER INDEX item_index REBUILD;
 
ɾ³ýË÷Òý
 
DROP INDEX item_index;
 
ΨһË÷Òý
 
q      ΨһË÷ÒýÈ·±£ÔÚ¶¨ÒåË÷ÒýµÄÁÐÖÐûÓÐÖØ¸´Öµ
q      Oracle ×Ô¶¯ÔÚ±íµÄÖ÷¼üÁÐÉÏ´´½¨Î¨Ò»Ë÷Òý
q      ʹÓÃCREATE UNIQUE INDEXÓï¾ä´´½¨Î¨Ò»Ë÷Òý
CREATE UNIQUE INDEX item_index
     ON itemfile (itemcode);
 
×éºÏË÷Òý
 
q     


Ïà¹ØÎĵµ£º

OracleÌåϵ½á¹¹Ö®£­Êý¾Ý¿â¡¢±í¿Õ¼ä¡¢ÊµÀý¼ò½é

Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£    
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼­Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼­Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼­ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......

RHEL5ÏÂOracle 10gÍêÕû°²×°ËµÃ÷£¬²»ÐŰ²²»³É¹¦£¡

1.×¼±¸¹¤×÷£º
°²×°32λ»ò64λRHEL5.4£¬°²×°Ïòµ¼Öв»ÐèҪѡÈκÎ×é¼þ£¬²»ÐèÒªÔ¤ÅäÖÃÈκÎÓû§£¬IPÊÇDHCP»ò¾²Ì¬½Ô¿É¡£
°²×°ºóÅäÖöîÍâ×é¼þ£º
yum -y install libXp,make,binutils,gcc,kernel-headers,glibc-headers,glibc-devel,libgomp
ÔÚx86_64ÉÏ»¹ÐèÒªcompat-libstdc++-33.x86_64
¶Ôx86£¬ÉÏ´«²¢½âѹ10201_database_lin ......

oracleÖÐʵÏÖ×ÔÔöÁÐ

1.´´½¨Ñ§Éú±í£º
CREATE TABLE student (
    xh number primary key,   
    Name varchar2(10) not null);
   
2. ´´½¨ÐòÁУº
CREATE SEQUENCE student_seq   
START WITH 1   
INCREMENT BY 1
NOCACHE;
°´»Ø³ ......

ORACLEÖÐLikeÓëInstrÐÔÄÜ´ó±ÈÆ´

t±íÖн«½üÓÐ1100ÍòÊý¾Ý£¬ºÜ¶àʱºò£¬ÎÒÃÇÒª½øÐÐ×Ö·û´®Æ¥Å䣬ÔÚSQLÓï¾äÖУ¬ÎÒÃÇͨ³£Ê¹ÓÃlikeÀ´´ïµ½ÎÒÃÇËÑË÷µÄÄ¿±ê¡£µ«¾­¹ýʵ¼Ê²âÊÔ·¢ÏÖ£¬likeµÄЧÂÊÓëinstrº¯Êý²î±ðÏ൱´ó¡£ÏÂÃæÊÇһЩ²âÊÔ½á¹û£º
SQL> set timing on
SQL> select count(*) from t where instr(title,’ÊÖ²á’)>0;
COUNT(*)
—&md ......

ORACLEÌåϵ½á¹¹


Ò»¡¢             ÄÚ´æ½á¹¹
¹²Ïí³Ø£º·ÖΪ¿â¸ßËÙ»º´æºÍ×Öµä¸ßËÙ»º³åÇø
¿â¸ßËÙ»º´æ£¬ÓÃÓÚ´æ´¢¾­¹ýÓï·¨·ÖÎö²¢ÇÒÕýÈ·µÄSQLÓï¾ä£¬²¢ËæÊ±×¼±¸Ö´ÐС£
×Öµä¸ßËÙ»º³åÇø£¬´æ´¢µÇ½µ½ORACLEµÄÓû§Ãû£¬¼°ÕâЩÓû§ÓÐÄÄЩÊý¾Ý¿â¶ÔÏóÒÔ¼°ÕâЩÊý¾Ý¿â¶ÔÏóµÄλÖá£
Êý¾Ý»º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ