oracle index type
Âß¼ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡¢É¾¡¢¸Ä£¨OLTP£©£»
²»ÄÜÓðüº¬OR²Ù×÷·ûµÄ²éѯ£»
Êʺϸ߻ùÊýµÄÁУ¨Î¨Ò»Öµ¶à£©
µäÐ͵ÄÊ÷×´½á¹¹£»
ÿ¸ö½áµã¶¼ÊÇÊý¾Ý¿é£»
´ó¶à¶¼ÊÇÎïÀíÉÏÒ»²ã¡¢Á½²ã»òÈý²ã²»¶¨£¬Âß¼ÉÏÈý²ã£»
Ò¶×Ó¿éÊý¾ÝÊÇÅÅÐòµÄ£¬´Ó×óÏòÓÒµÝÔö£»
ÔÚ·ÖÖ§¿éºÍ¸ù¿éÖзŵÄÊÇË÷ÒýµÄ·¶Î§£»
Bitmap:
ÊʺÏÓë¾ö²ßÖ§³Öϵͳ£»
×öUPDATE´ú¼Û·Ç³£¸ß£»
·Ç³£ÊʺÏOR²Ù×÷·ûµÄ²éѯ£»
»ùÊý±È½ÏÉÙµÄʱºò²ÅÄܽ¨Î»Í¼Ë÷Òý£»
Ê÷Ðͽṹ£º
Ë÷ÒýÍ·
¿ªÊ¼ROWID£¬½áÊøROWID£¨ÏÈÁгöË÷ÒýµÄ×î´ó·¶Î§£©
BITMAP
ÿһ¸öBIT¶ÔÓ¦×ÅÒ»¸öROWID£¬ËüµÄÖµÊÇ1»¹ÊÇ0£¬Èç¹ûÊÇ1£¬±íʾ×ÅBIT¶ÔÓ¦µÄROWIDÓÐÖµ£»
B*treeË÷ÒýµÄ»°Í¨³£ÔÚ·ÃÎÊСÊý¾ÝÁ¿µÄÇé¿öϱȽÏÊÊÓ㬱ÈÈçÄã·ÃÎʲ»³¬¹ý±íÖÐÊý¾ÝµÄ5%£¬µ±È»ÕâÖ»ÊǸöÏà¶ÔµÄ±ÈÂÊ£¬ÊÊÓÃÓÚÒ»°ãµÄÇé¿ö¡£bitmapµÄ»°ÔÚÊý¾Ý²Ö¿âÖÐʹÓý϶࣬ÓÃÓڵͻùÊýÁУ¬±ÈÈçÐÔ±ðÖ®ÀàÖظ´ÖµºÜ¶àµÄ×ֶΣ¬»ùÊýԽСԽºÃ¡£
Ïà¹ØÎĵµ£º
±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......
SQLServerºÍOracleÊÇ´ó¼Ò¾³£Óõ½µÄÊý¾Ý¿â£¬ÔÚ´Ë×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©
´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:s ......
ÒòΪǿÖƹػú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......
2010Äê3ÔÂ5ÈÕ£¬ËäÈ»º®·ç´Ì¹Ç£¬µ«ÒÀÈ»µ²²»×¡¹«Ë¾Í¬ÊºÍÎÒ¹¤×÷µÄÈÈÇé.µÎ´ð¡¢µÎ´ð,ͬÊÂÊÖ»úÏìÁË£¬ÀÏ×ܸøËû´òµç»°£¬Ëµ¹ã¶«ÁªÍ¨ÍøÓÅƽ̨Êý¾Ý¿â³öÏÖÎÊÌ⣬ÓÉÓÚÊý¾ÝÁ¿È·Êµ¹ý´ó£¬Í¬ÊÂÒÔÇ°Ò²´¦Àí¹ýÄDZߵÄÎÊÌ⣬Ö÷ÒªÊÇËùÓÐÊý¾ÝÁ¿´óµÄ±íÿ¸ôÒ»Ì콨Á¢Ò»¸öË÷Òý£¬ÕâÑù²éѯÊý¾ÝËٶȱȽϿ졣µ«ÊǽøÐÐÊý¾Ý»ã× ......