ÎÄÕ | ÎÄÕÂÁбí>> |
2008-04-21 21:38:00
2008-04-07 01:49:00
2008-04-06 21:56:00
2008-04-05 11:34:00
2008-03-24 12:12:00
2008-03-24 12:06:00
2008-03-24 12:05:00
2008-03-24 12:03:00
2008-03-24 12:02:00
2008-03-24 11:57:00
2008-03-24 11:55:00
µ¼¶Á£º
¡¡¡¡oracle ·¢±íÓÚ:2006.11.15 10:27 ::·ÖÀà: ( Ò»°ã·ÖÀà) ::ÔĶÁ:(310´Î) :: ÆÀÂÛ (0)
±¾ÎÄת×Ô
http://oracle.itpub.net/
¡¡¡¡oracle ·¢±íÓÚ:2006.11.15 10:27 ::·ÖÀà: ( Ò»°ã·ÖÀà) ::ÔĶÁ:(310´Î) :: ÆÀÂÛ (0)
±¾ÎÄת×Ô
http://oracle.itpub.net/
2008-03-24 11:49:00
2008-03-24 11:47:00
2008-03-24 11:02:00
µ¼¶Á£º
¡¡¡¡with t as (select level as n from dual connect by level <=9)
¡¡¡¡select sys_connect_by_path(b.n || '*' || a.n || '=' || a.n * b.n, ' ') as ¾Å¾Å³Ë·¨±í
¡¡¡¡from t a, t b
¡¡¡¡where a.n >= b.n and level = a.n
¡¡¡¡start with b.n=1
¡¡¡¡connect by a.n=prior a.n and b.n=prior b.n+1;
±¾ÎÄת×Ô
http://woodnan.itpub.net/post/37055/457860
¡¡¡¡with t as (select level as n from dual connect by level <=9)
¡¡¡¡select sys_connect_by_path(b.n || '*' || a.n || '=' || a.n * b.n, ' ') as ¾Å¾Å³Ë·¨±í
¡¡¡¡from t a, t b
¡¡¡¡where a.n >= b.n and level = a.n
¡¡¡¡start with b.n=1
¡¡¡¡connect by a.n=prior a.n and b.n=prior b.n+1;
±¾ÎÄת×Ô
http://woodnan.itpub.net/post/37055/457860
2008-03-24 11:00:00
µ¼¶Á£º
¡¡¡¡ÓÉÓÚÓ¦Óÿª·¢µÄÎÊÌ⣬Êý¾Ý¿â´æÔÚ´óÁ¿µÄSQLÓ²½âÎö£¬ÐÔÄܳöÏֺܴóÎÊÌâ¡£¿¼ÂÇÉèÖòÎÊýcursor_sharing=similar½â¾öÓ²½âÎöÎÊÌ⣬µ«ÊÇ10gÔÚ×Ô¶¯ÊÕ¼¯Í³¼ÆÖµ»áĬÈÏÊÕ¼¯histogram£¬ÒÀÈ»»áÓ°ÏìSQLµÄ½âÎöÐÔÄÜ¡£´ËÎÊÌâ¿ÉÒÔʹÓÃÏÂÁз½·¨½â¾ö£º
¡¡¡¡ÐÞ¸ÄĬÈÏÊÕ¼¯Ä£Ê½£¬ÒÀȻʹÓÃ10g×Ô¶¯ÊÕ¼¯Í³¼ÆÖµµÄ¹¦ÄÜ
¡¡¡¡exec dbms_stats.set_param('method_opt','for columns null');
±¾ÎÄת×Ô
http://woodnan.itpub.net/post/37055/457862
¡¡¡¡ÓÉÓÚÓ¦Óÿª·¢µÄÎÊÌ⣬Êý¾Ý¿â´æÔÚ´óÁ¿µÄSQLÓ²½âÎö£¬ÐÔÄܳöÏֺܴóÎÊÌâ¡£¿¼ÂÇÉèÖòÎÊýcursor_sharing=similar½â¾öÓ²½âÎöÎÊÌ⣬µ«ÊÇ10gÔÚ×Ô¶¯ÊÕ¼¯Í³¼ÆÖµ»áĬÈÏÊÕ¼¯histogram£¬ÒÀÈ»»áÓ°ÏìSQLµÄ½âÎöÐÔÄÜ¡£´ËÎÊÌâ¿ÉÒÔʹÓÃÏÂÁз½·¨½â¾ö£º
¡¡¡¡ÐÞ¸ÄĬÈÏÊÕ¼¯Ä£Ê½£¬ÒÀȻʹÓÃ10g×Ô¶¯ÊÕ¼¯Í³¼ÆÖµµÄ¹¦ÄÜ
¡¡¡¡exec dbms_stats.set_param('method_opt','for columns null');
±¾ÎÄת×Ô
http://woodnan.itpub.net/post/37055/457862
2008-03-21 21:05:00
2008-03-21 20:55:00
2008-01-09 21:11:00
2008-01-09 21:09:00
2008-01-09 21:08:00
51CTOÍÆ¼ö²©ÎÄ | ¸ü¶à.. |


Å£º£±ò µÄBLOG
²©¿Íͳ¼ÆÐÅÏ¢
×îÐÂÆÀÂÛ
ÓÑÇéÁ´½Ó
ÎÄÕÂ
51CTOÍÆ¼ö²©ÎÄ
¹«¸æ
ÈÈÃÅÎÄÕÂ
51CTOÍÆ¼ö²©¿Í