[B! SQL] nudgeemallã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nudgeemall id:nudgeemall

SQLã«é–¢ã™ã‚‹nudgeemallã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

å®Ÿè¡Œãƒ—ãƒ©ãƒ³ã‚’èªã‚€ - æ´»ç”¨ç·¨ (ãã® 1) - ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ç¥žè°· é›…ç´€ Esclation Engineer å‰å›žã¾ã§ã®å†…å®¹ã§ã€å®Ÿè¡Œãƒ—ãƒ©ãƒ³ã‹ã‚‰ã‚¯ã‚¨ãƒªãŒã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ã§ã¯ã€æ¬¡ã«ã€å®Ÿè¡Œãƒ—ãƒ©ãƒ³ã‚’æ´»ç”¨ã—ã¦ã€ã‚¯ã‚¨ãƒªã®ç„¡é§„ã‚’çœãã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†æ–¹æ³•ã‚’è€ƒãˆã¦ã¿ã¾ã—ã‚‡ã†ã€‚ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€‚ã©ã®ã‚¯ã‚¨ãƒªã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å¯¾è±¡ã«ã™ã‚‹ã‹ã€ã‚¯ã‚¨ãƒªã®ã©ã®éƒ¨åˆ†ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å¯¾è±¡ã¨ã™ã‚‹ã‹ã‚’æ±ºå®šã™ã‚‹å ´åˆã¯ã€ã‚¢ãƒ ãƒ€ãƒ¼ãƒ«ã®æ³•å‰‡ã‚’è€ƒæ…®ã—ã¦ã€æŽ›ã‹ã‚‹ã‚³ã‚¹ãƒˆã¨åŠ¹æžœã‚’è¦‹æ¥µã‚ãªãŒã‚‰ã€æ…Žé‡ã«æ±ºå®šã™ã‚‹ã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ Key Lookup (Clustered Index Seek Lookup) ã‚„ RID Lookup ã‚’æŽ’é™¤ã™ã‚‹ æ¬¡ã®å®Ÿè¡Œãƒ—ãƒ©ãƒ³ã«ã¯ã€Key Lookup ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ SET SHOWPLAN_ALL ãªã©ã® regacy ãƒ—ãƒ©ãƒ³è¡¨ç¤ºã§ã¯ã€ä¸‹ã®ã‚ˆã†ã« Lookup å¥ä»˜ã Clustered Index Seek ãŒå«ã¾ã‚Œã¾ã™ã€‚
nudgeemall 2016/08/25
sqlserver

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

sql

microsoft
ãƒªãƒ³ã‚¯
ç¾åœ¨å®Ÿè¡Œä¸ã®SQLã‚’ç¢ºèªã—ã¤ã¤v$sessionã®ãƒ†ãƒ¼ãƒ–ãƒ«ã£ã¦ãªã‚“ã ã£ãŸã‹æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚‹ - by shigemk2
Oracle_ç¾åœ¨å®Ÿè¡Œä¸ã®SQLã‚’ç¢ºèªã™ã‚‹æ–¹æ³• | æ‰‹é †æ›¸.com V$SESSION ã ã„ãŸã„ã“ã‚Œã§ä»Šç¾åœ¨å®Ÿè¡Œä¸ã®SQLãŒå¼•ã£ã“æŠœã‘ã‚‹ã‚“ã ã‘ã©ã€v$sessionã£ã¦ãªã‚“ã ã£ã‘ã€v$sql textã£ã¦ãªã‚“ã ã£ã‘ã£ã¦æ€ã„ãªãŒã‚‰ç”Ÿãã¦ã„ã‚‹ã€‚ select a.username, a.sid, a.serial#, a.machine, a.wait_time, b.sql_text from v$session a, v$sql text b where a.sql_address = b.address and a.sql_hash_value = b.hash_value and b.piece = 0 and a.username is not null and a.status = 'ACTIVE' order by a.username, a.sid, b.piece;
nudgeemall 2016/03/22
oracle

SQL
ãƒªãƒ³ã‚¯
è¡¨é ˜åŸŸä½¿ç”¨çŽ‡ã®ç¢ºèªæ–¹æ³• ï½œ Oracleä½¿ã„ã®ãƒã‚¿å¸³
è¡¨é ˜åŸŸã®ç›£è¦–ã¯é‡è¦ Oracle DB ã®é‹ç”¨ã§ã¯ã€è¡¨é ˜åŸŸã®ç›£è¦–ãŒã¨ã¦ã‚‚é‡è¦ã€‚ è¡¨é ˜åŸŸã«æ‰€å±žã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®åˆæœŸã‚µã‚¤ã‚ºã‚’å°ã•ãå®šç¾©ã—ã¦ã„ã‚‹å ´åˆã¯ã€ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«è‡ªå‹•æ‹¡å¼µã«ã‚ˆã‚Šä¸€æ™‚çš„ã«ä½¿ç”¨çŽ‡ãŒä¸‹ãŒã‚‹ã‚ˆã†ã«è¦‹ãˆã‚‹ãŸã‚ã€ ç›£è¦–é–¾å€¤ã«ã‚ˆã£ã¦ã¯ã€å•é¡ŒãŒè¡¨é¢åŒ–ã—ã«ãã„ã“ã¨ã‚‚ã‚ã‚‹ã®ã§æ³¨æ„ã€‚ ç‰¹ã« SYSTEM è¡¨é ˜åŸŸãŒæž¯æ¸‡ã—ã¦ sql*plus ã§ãƒã‚°ã‚¤ãƒ³ã™ã‚‰å‡ºæ¥ãªã„ã¨ã„ã† äº‹æ…‹ã«ãªã£ãŸã‚‰ç›®ã‚‚å½“ã¦ã‚‰ã‚Œãªã„ã€‚ Enterprise Manager ã§ç¢ºèªã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ãŒã€ã“ã“ã§ã¯ SQL ã§å–å¾—ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ è¡¨é ˜åŸŸã”ã¨ã®åˆè¨ˆã‚µã‚¤ã‚ºã€ä½¿ç”¨ã‚µã‚¤ã‚ºã€ç©ºãã‚µã‚¤ã‚ºã€ä½¿ç”¨çŽ‡ãªã©ã®æƒ…å ±ã‚’å‚ç…§ã™ã‚‹ã«ã¯ã€ ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªã® dba_data_filesã€dba_free_space ã‚’ç¢ºèªã™ã‚‹ã€‚ â€» set ã‚³ãƒžãƒ³ãƒ‰ã‚„ã€col ã‚³ãƒžãƒ³ãƒ‰ã¯ãŠå¥½ã¿ã§ã€‚ è¡¨é ˜åŸŸã®ä½¿ç”¨é‡ã€ç©ºãå®¹é‡å–å¾—SQLã‚µãƒ³ãƒ—ãƒ« SQL>
nudgeemall 2016/02/22
oracle

SQL
ãƒªãƒ³ã‚¯
åˆ†æžé–¢æ•°ã®è¡æ’ƒï¼ˆä¸ç·¨ï¼‰
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
nudgeemall 2015/07/03
SQL

åˆ†æžé–¢æ•°

åˆ†æžé–¢æ•°ã®è¡æ’ƒ
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
nudgeemall 2015/02/05
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL

database

DB
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
nudgeemall 2014/10/22
performance

SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1