[SQL]SQLÐÔÄܵ÷ÓÅ
³õ¼¶Æª —— ¼òµ¥²éѯÓï¾äµÄµ÷ÓÅ ÀîÃ÷»Û , Èí¼þ¹¤³Ìʦ, IBM
ÀîÃ÷»Û£¬ÔÚ IBM ÖйúÈí¼þ¿ª·¢ÖÐÐÄ Data Studio ÍŶӹ¤×÷´ÓÊ InfoSphere Warehouse Administration Console µÄ¹¦ÄܲâÊÔ¹¤×÷¡£ÔøÔÚ developerWorks ·¢±í¡¶½« DB2 DWE 9.1.X ǨÒƵ½ DB2 Warehouse 9.5¡·¡¢¡¶InfoSphere Warehouse SQL ²Ö´¢ÃüÁîÐнӿڡ·¡¢¡¶Linux ÏÂÀûÓà squid ·´Ïò´úÀíÌá¸ßÍøÕ¾ÐÔÄÜ¡·ÒÔ¼°¡¶InfoSphere Warehouse Administration Console µÄ¶Ô±È½éÉÜ¡·µÈÎÄÕ¡£
¼ò½é£º ¾³£Ìýµ½ÓÐ×öÓ¦ÓõÄÅóÓѱ§Ô¹Êý¾Ý¿âµÄÐÔÄÜÎÊÌ⣬±ÈÈç·Ç³£µÍµÄ²¢·¢£¬ÁîÈ˱ÀÀ£µÄÏìӦʱ¼ä£¬³¤Ê±¼äµÄËøµÈ´ý£¬ËøÉý¼¶,ÉõÖÁÊÇËÀËø£¬µÈµÈ¡£±¾ÎÄÕë¶ÔÓ¦Óÿª·¢ÈËÔ±¾³£½Ó´¥µÄ SQL Êéд²¿·Ö½øÐÐÓÅ»¯£¬ÒÔÆÚÍûÄܶÔÊý¾Ý¿â¿ª·¢ÈËÔ±ÓÐËù°ïÖú¡£
¾³£Ìýµ½ÓÐ×öÓ¦ÓõÄÅóÓѱ§Ô¹Êý¾Ý¿âµÄÐÔÄÜÎÊÌ⣬±ÈÈç·Ç³£µÍµÄ²¢·¢£¬ÁîÈ˱ÀÀ£µÄÏìӦʱ¼ä£¬³¤Ê±¼äµÄËøµÈ´ý£¬ËøÉý¼¶ , ÉõÖÁÊÇËÀËø£¬µÈµÈ¡£ÔÚ½â¾öÕâЩÎÊÌâµÄ¹ý³ÌÖУ¬DBA ¾³£·¢ÏÖÓ¦Óÿª·¢ÈËÔ±¶ÔÊý¾Ý¿âµÄ“ÎóÓÔ¡£°üÀ¨ , ·µ»Ø¹ý¶à²»±ØÒªµÄÊý¾Ý , ²»±ØÒªºÍ²»Êʵ±¼ÓËø£¬¶Ô¸ôÀ뼶±ðµÄÎóÓúͶԴ洢¹ý³ÌµÄÎóÓõȵȡ£µ«ÊÇ£¬Ãæ¶ÔºÆÈçÑ̺£µÄÊý¾Ý¿â֪ʶ , ÒªÇóÍêÈ«ÕÆÎÕ , ¶ÔÓ¦Óÿª·¢ÈËÔ±À´ËµÒ²È·Êµ¿ÝÔï¼èÉî . Òò´Ë£¬±ÊÕßÌرðÌáÁ¶¶ÔÓ¦Óÿª·¢ÈËÔ±ÓаïÖúµÄ SQL Êéд²¿·Ö£¬ÒÔÆÚÍûÄܶÔÊý¾Ý¿â¿ª·¢ÈËÔ±ÓÐËù°ïÖú¡£
“¸ù¾ÝÎÒÃǵľÑ飨ÓɺܶàÒµ½çר¼ÒÖ¤Ã÷£©£¬ÔÚ SQL Server ÉÏÈ¡µÃµÄÐÔÄÜÌá¸ßÓÐ 80% À´×Ô¶Ô SQL ±àÂëµÄ¸Ä½ø£¬¶ø²»ÊÇÀ´×ÔÓÚ¶ÔÓÚÅäÖûòϵͳÐÔÄܵĵ÷Õû¡£”
—¿ÎÄ ¿ËÀ³¶÷µÈ£¬Transact-SQL Programming ×÷Õß
“¾Ñé±íÃ÷ 80%-90% µÄÐÔÄܵ÷ÓÅÊÇÔÚÓ¦Óü¶×öµÄ£¬¶ø²»ÊÇÔÚÊý¾Ý¿â¼¶”
—ÍÐÂí˹ °×ÌØ£¬Expert One on One: Oracle ×÷Õß
±¾ÎĽ«Ö÷ÒªÌÖÂÛ»ùÓÚÓï·¨µÄÓÅ»¯ÒÔ¼°¼ò¼òµ¥µÄ²éѯÌõ¼þ¡£»ùÓÚÓï·¨µÄÓÅ»¯Ö¸µÄÊÇΪ²»¿¼ÂÇÈκεķÇÓï·¨ÒòËØ£¨ÀýÈ磬Ë÷Òý£¬±í´óСºÍ´æ´¢µÈ£©£¬½ö¿¼ÂÇÔÚ SQL Óï¾äÖжÔÓÚ´ÊÓïµÄÑ¡ÔñÒÔ¼°ÊéдµÄ˳Ðò¡£
Ò»°ã¹æÔò
ÕâÒ»²¿·Ö£¬½«¿´Ò»ÏÂһЩÔÚÊéд¼òµ¥²éѯÓïʱÐèҪעÒâµÄͨÓõĹæÔò¡£
¸ù¾ÝȨֵÀ´ÓÅ»¯²éѯÌõ¼þ
×îºÃµÄ²éѯÓï¾äÊǽ«¼òµ¥µÄ±È½Ï²Ù×÷×÷ÓÃÓÚ×îÉÙµÄÐÐÉÏ¡£ÒÔÏÂÁ½ÕÅ±í£¬±í 1 ºÍ±í 2 ÒÔÓɺõ½²îµÄ˳ÐòÁгöÁ˵äÐͲéѯÌõ¼þ²Ù×÷·û²¢¸³ÓëȨֵ¡£
±í 1. ²éѯÌõ¼þÖвÙ×÷·ûµÄÈ
Ïà¹ØÎĵµ£º
SQL*PLUSµÄʹÓÃ
1¡¢Í˳öSQL*PLUS
EXIT£ºÖÕÖ¹SQL*PLUS£¬²¢½«¿ØÖÆȨ½»»¹¸øOS¡£
2¡¢±à¼ÃüÁî
1) List»òL£ºÏÔʾ»º³åÇøÖÐËùÓеÄÐС£
SQL> list
1 select
2 *
3* from dept --×¢£º*´ú±íµ±Ç°ÐС£ ......
ÐÔÄܼà¿ØÖ®¼à¿ØSQLÓï¾ä
·ÖÎö±í
analyze table tablename compute statistics for all indexes;
analyze table tablename compute statistics for all indexed columns;
analyze table tablename compute statistics for table;
¼à¿ØÊÂÀýµÄµÈ´ý
select event,sum(decode(wait_Tim ......
²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
1. CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼±í´ïʽÀ´ÅжÏÊý¾ ......
Èç¹ûÄúÔÚ°²×°SQL Server 2005ʱ³öÏÖ¼ÆÊýÆ÷´íÎó
µã»÷¿ªÊ¼£ÔËÐÐÊäÈë"cmd"£¬È·¶¨ºó½øÈëÃüÁî´°¿Ú£¬ÒÀ´ÎÊäÈëÏÂÃæ4ÌõÃüÁîɾ³ý4¸ö¼ÆÊýÆ÷£º
unlodctr w3svc
unlodctr msftpsvc
unlodctr asp
unlodctr inetinfo
È»ºóÔÙÒÀ´ÎÊäÈëÏÂÃæ4ÌõÃüÁîÖØ×°4¸ö¼ÆÊýÆ÷£º
lodctr w3ctrs.ini
lodctr ftpctrs.ini
lodctr axperf.ini
lod ......
[ORACLE]
ÏîÄ¿ÖÐÓöµ½Ò»¸öÐèÇó£¬ÐèÒª½«¶àÐкϲ¢ÎªÒ»ÐС£
±í½á¹¹ÈçÏ£º
NAME Null ......