[B! index] xai1981ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

xai1981 id:xai1981

indexã«é–¢ã™ã‚‹xai1981ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (21)

${{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}}

ãƒ’ãƒ³ãƒˆæ–‡ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ‡å®šã—ã¦SQLã‚’å®Ÿè¡Œã™ã‚‹ (WITH(INDEX())ï¼‰ - SQL Server - Project Group
SQL ã‚’å®Ÿè¡Œã—ãŸã¨ãæƒ³å®šã—ãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ç”¨ã•ã‚Œãšãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒã§ãªã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ’ãƒ³ãƒˆæ–‡ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æŒ‡å®šã—ã¦å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’1ã¤æŒ‡å®šã™ã‚‹å ´åˆ æ–‡æ³•ï¼šWITH (INDEX(ï¼œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å1ï¼ž))
xai1981 2019/07/19
sql_server

tuning

index
ãƒªãƒ³ã‚¯
çµ±è¨ˆæƒ…å ±ã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã«ã¤ã„ã¦ at SE ã®é›‘è¨˜
çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã€ä½œæˆã™ã‚‹ã¨ãã«ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ãƒ¬ãƒ¼ãƒˆã‚’æŒ‡å®šã—ãªã„ã¨æ—¢å®šã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ãŒè¨å®šã•ã‚Œã¾ã™ã€‚ UPDATE STATISTICS (Transact-SQL) çµ±è¨ˆ ç¾åœ¨è¨å®šã•ã‚Œã¦ã„ã‚‹çµ±è¨ˆæƒ…å ±ãŒã©ã®ç¨‹åº¦ã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã§ä½œæˆã•ã‚Œã¦ã„ã‚‹ã‹ç¢ºèªã™ã‚‹ãŸã‚ã®æ–¹æ³•ã‚’ã™ã“ã—ã¾ã¨ã‚ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ â– çµ±è¨ˆæƒ…å ±ã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã®ç¢ºèª ç¾åœ¨ä½œæˆã•ã‚Œã¦ã„ã‚‹çµ±è¨ˆæƒ…å ±ã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã§ã™ãŒã€DBCC SHOWSTATISTICS ã§ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ # STAT_HEADER ã‚’è¨å®šã™ã‚‹ã“ã¨ã§ã€ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ã„ã‚‹ãƒ˜ãƒƒãƒ€ãƒ¼æƒ…å ±ã ã‘ã‚’è¡¨ç¤ºã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å®Ÿè¡Œçµæžœã® [Rows] ã¨ [Rows Sampled] ã‚’ç¢ºèªã™ã‚‹ã“ã¨ã§å…¨ä½“è¡Œã«å¯¾ã—ã¦ã©ã‚Œãã‚‰ã„ã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã§çµ±è¨ˆæƒ…å ±ãŒä½œæˆã•ã‚ŒãŸã‹ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ DBCC ã‚³ãƒžãƒ³ãƒ‰ã§å–å¾—ã—ã¦ã„ã‚‹ã®ã§ã€å…¨çµ±è¨ˆã®ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚°ã‚’å–å¾—ã™ã‚‹ãŸã‚ã«ã¯ã‚«
xai1981 2018/08/07
sql_server

tuning

index
ãƒªãƒ³ã‚¯
ROW_NUMBER() OVER (PARTITION BY B,A ORDER BY C) doesn't use index on (A,B,C)
xai1981 2018/08/03
sql_server

index

stack_overflow
ãƒªãƒ³ã‚¯
Understanding Rebinds and Rewinds
xai1981 2018/08/02
sql_server

index
ãƒªãƒ³ã‚¯
Correct SQL index for Partition + Order to remove SORT
xai1981 2018/08/02
stack_overflow

sql_server

index
ãƒªãƒ³ã‚¯
SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°: ã‚½ãƒ¼ãƒˆã‚’ç™ºç”Ÿã•ã›ãªã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆ - Qiita
SQLã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã¨ãã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚ŠãŒã¡ãªæ¼”ç®—ã®1ã¤ã«ã‚½ãƒ¼ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸¦ã³æ›¿ãˆã‚‹ãŸã‚ã€ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šã‘ã‚Œã°å¤šã„ã»ã©ãã®ã‚³ã‚¹ãƒˆã‚‚å¢—å¤§ã—ã¦ã„ãã¾ã™ã€‚ ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã™ã‚‹ã‚±ãƒ¼ã‚¹ã¯ã„ã‚ã„ã‚ã‚ã‚Šã¾ã™ãŒã€ä»£è¡¨çš„ãªã®ã¯ã€ŒOrder BYã€å¥ã§æ˜Žç¤ºçš„ã«ãƒ‡ãƒ¼ã‚¿ã®ä¸¦ã³æ›¿ãˆã‚’æŒ‡å®šã™ã‚‹å ´åˆã§ã™ãã€‚ -- intåž‹ã®ã‚«ãƒ©ãƒ ãŒ5ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ« 100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰INSERTæ¸ˆ -- SQLServerã§å®Ÿè¡Œ SELECT column4 ,column5 FROM SomeTable WHERE column2 = 2 ORDER BY column3 -- ä¸¦ã³æ›¿ãˆ
xai1981 2018/08/02
ã‚ã¨ã§èªã‚€

qiita

sql_server

index
ãƒªãƒ³ã‚¯
SQLServer: æŒ‡å®šã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½¿ç”¨çŠ¶æ³ã‚’å–å¾—ã™ã‚‹ - Qiita
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ãŸã®ã¯è‰¯ã„ã‘ã©ã€æœ¬å½“ã«ã¡ã‚ƒã‚“ã¨æ„å›³ã—ãŸä½¿ã‚ã‚Œæ–¹ã‚’ã—ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚ŠãŸã„ã¨ãã‚ã‚Šã¾ã™ã‚ˆãã€‚ ä¸‹è¨˜ã®SQLã§ã€ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹åˆ©ç”¨çŠ¶æ³ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ»seekã§ä½¿ã‚ã‚Œã‚‹ã¤ã‚‚ã‚Šã§ä½œã£ãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§scanãŒå¤šç”¨ã•ã‚Œã¦ã„ãªã„ã‹ï¼Ÿ ãƒ»scanã§ä½¿ã‚ã‚Œã‚‹ã¤ã‚‚ã‚Šã§ä½œã£ãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§seekãŒå¤šç”¨ã•ã‚Œã¦ã„ãªã„ã‹ï¼Ÿï¼ˆã“ã£ã¡ã¯ç¨€ã§ã™ãï¼‰ ãªã©ç¢ºèªã§ãã¾ã™ã€‚ â€»å®Ÿè¡Œã«ã¯VIEW SERVER STATE æ¨©é™ãŒå¿…è¦ã§ã™ã€‚ SELECT o.name AS table_name , i.name AS index_name , s.user_seeks -- Index Seek æ•° , s.user_scans -- Index Scan æ•° , s.user_updates -- UPDATE æ•° , s.user_lookups -- lookup æ•° , la
xai1981 2018/08/02
qiita

sql_server

index
ãƒªãƒ³ã‚¯
SQL Server ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆç³»æŠ€è¡“æƒ…å ± Wiki
xai1981 2018/08/02
sql_server

index
ãƒªãƒ³ã‚¯
â—†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ ã¨å†…éƒ¨å‹•ä½œï¼’
è‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆä¸»ã‚ãƒ¼åˆ¶ç´„ã¨ UNIQUE åˆ¶ç´„ï¼‰ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ãŒã‚ã‚‹å ´åˆã®éžã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†…éƒ¨æ§‹é€ ã‚«ãƒãƒªãƒ³ã‚° ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼‰ ä»˜åŠ åˆ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆInclude ã‚ªãƒ—ã‚·ãƒ§ãƒ³ï¼‰ è‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆä¸»ã‚ãƒ¼åˆ¶ç´„ã¨ UNIQUE åˆ¶ç´„ï¼‰ PRIMARY KEYï¼ˆä¸»ã‚ãƒ¼ï¼‰åˆ¶ç´„ã¾ãŸã¯ UNIQUE åˆ¶ç´„ã‚’è¨å®šã—ã¦ã„ã‚‹å ´åˆã¯ã€è‡ªå‹•çš„ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½œæˆã•ã‚Œã¾ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã€PRIMARY KEYåˆ¶ç´„ã®å ´åˆã«ã¯ã€Œã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã€UNIQUEåˆ¶ç´„ã®å ´åˆã«ã¯ã€Œéžã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãŒä½œæˆã•ã‚Œã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åå‰ã¯åˆ¶ç´„ã®åå‰ã¨åŒã˜ã«ãªã‚Šã¾ã™ã€‚ ã©ã¡ã‚‰ã®åˆ¶ç´„ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ„ã«ä¿ã¤ãŸã‚ã®ã‚‚ã®ãªã®ã§ã€ã“ã®åˆ—ã‚’æ¤œç´¢æ¡ä»¶ã«æŒ‡å®šã—ãŸå ´åˆã¯ã€å¿…ãš ï¼‘ä»¶ã®æ¤œç´¢çµæžœãŒè¿”ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã®ä¸ã‹ã‚‰æ•°ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šå‡ºã™ã¨ãã«æœ€ã‚‚
xai1981 2018/08/02
sql_server

index

sql
ãƒªãƒ³ã‚¯
Selectã™ã‚‹åˆ—ã®å¤‰æ›´ã«ã‚ˆã£ã¦ã€Whereå¥ã§ä½¿ã‚ã‚Œã‚‹IndexãŒå¤‰åŒ–ã™ã‚‹ç†ç”±ã‚’æ•™ãˆã¦ãã ã•ã„ã€‚
ã“ã®ãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œãªããªã‚Šã¾ã—ãŸã€‚ Microsoft Edge ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹ã¨ã€æœ€æ–°ã®æ©Ÿèƒ½ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ›´æ–°ãƒ—ãƒã‚°ãƒ©ãƒ ã€ãŠã‚ˆã³ãƒ†ã‚¯ãƒ‹ã‚«ãƒ« ã‚µãƒãƒ¼ãƒˆã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ è³ªå• 2017å¹´6æœˆ1æ—¥æœ¨æ›œæ—¥ 6:24 ã„ã¤ã‚‚ãŠä¸–è©±ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ SQLã®æŒ™å‹•ã‚’ç¢ºèªã—ã¦ãŠã‚Šã¾ã—ã¦ã€ä»Šã®çŸ¥è˜ãƒ¬ãƒ™ãƒ«ã§ã¯ä¸å¯è§£ãªäº‹ãŒã‚ã‚Šã€ã”åŠ©åŠ›ã„ãŸã ã‘ã¾ã›ã‚“ã§ã—ã‚‡ã†ã‹ã€‚ â—†ç™ºç”Ÿã—ã¦ã„ã‚‹ã“ã¨ Index ãŒä½¿ã‚ã‚Œã‚‹æƒ³å®šã§where å¥ã‚’æŒ‡å®šã—ã¦ã„ã‚‹ãŒ Selectå¥ã« *ã€€ã‚’æŒ‡å®šã—ãŸã‚Šã€éžä¸»ã‚ãƒ¼åˆ—ã‚’æŒ‡å®šã—ãŸã‚Šã™ã‚‹ã“ã¨ã§ã€æƒ³å®šã—ã¦ã„ã‚‹Indexã§ã¯ãªã Clustered Index Scan ã¨ãªã‚‹ã€‚ Selectå¥ã«ä¸»ã‚ãƒ¼ã‚’å°„å½±ã™ã‚‹ã¨ã€æƒ³å®šã©ãŠã‚ŠIndex Seekã«ãªã‚‹ã€‚ ã€å®Ÿéš›ã«è¡Œã£ãŸã“ã¨ã€‘ â—†ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆæ–‡ USE [TESTDB] GO SET ANSI_NULLS ON GO SET QUO
xai1981 2018/07/30
sql_server

index
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿é‡ãŒå¢—ãˆãŸæ™‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã®é‡ã¯ã€ãã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’ä¸Žãˆã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è¿½åŠ ã®ãƒ‡ãƒ¼ã‚¿ãŒåŠ ã‚ã‚‹ã“ã¨ã«ã‚ˆã‚Š ã‚ã‚‹ã‚¯ã‚¨ãƒªãŒé…ããªã‚‹ã®ã¯ã€ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ã—ã‹ã—ã€ãƒ‡ãƒ¼ã‚¿é‡ãŒ2å€ã«ãªã£ãŸæ™‚ã®å½±éŸ¿ã¯ã©ã®ä½ã§ã—ã‚‡ã†ã‹ï¼Ÿã¾ãŸã€ãã®å½±éŸ¿ã®æ¯”çŽ‡ã‚’æ”¹å–„ã™ã‚‹ã«ã¯ ã©ã†ã—ãŸã‚‰ã‚ˆã„ã§ã—ã‚‡ã†ã‹ï¼Ÿã“ã‚Œã‚‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’è€ƒãˆã‚‹ä¸Šã§é‡è¦ãªå•ã„ã‹ã‘ã§ã™ã€‚ ä¾‹ã¨ã—ã¦ã€2ã¤ã®ç•°ãªã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸæ™‚ã®ä»¥ä¸‹ã®ã‚¯ã‚¨ãƒªã®å¿œç”æ™‚é–“ã‚’èª¿ã¹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å®šç¾©ã¯ã€ä»Šã®ã¨ã“ã‚ã¯ ä¼ã›ã¦ãŠãã¾ã™ã€‚ã“ã‚Œä»¥é™ã®è§£èª¬ã®ä¸ã§ã€æ˜Žã‚‰ã‹ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ SELECT count(*) FROM scale_data WHERE section = ? AND id2 = ?SECTIONåˆ—ã¯ã“ã®ã‚¯ã‚¨ãƒªã«ãŠã„ã¦ã€ãƒ‡ãƒ¼ã‚¿é‡ã‚’åˆ¶å¾¡ã™ã‚‹ã¨ã„ã† ç‰¹åˆ¥ãªå½¹å‰²ãŒã‚ã‚Šã¾ã™ã€‚SECTIONã®æ•°ãŒå¢—ãˆã‚‹ã¨ã€é¸æŠžã•ã‚Œã‚‹è¡Œ
xai1981 2018/07/27
sql_server

index

tuning
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®çµ±è¨ˆã®ä½¿ç”¨
é©ç”¨å¯¾è±¡: SQL Server 2022 (16.x) Azure SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Azure SQL Managed Instance ã‚¯ã‚¨ãƒª ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãƒ¼ã§ã¯ã€ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ã‚¯ã‚¨ãƒª ãƒ—ãƒ©ãƒ³ã‚’ä½œæˆã™ã‚‹ãŸã‚ã«çµ±è¨ˆã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã»ã¨ã‚“ã©ã®ã‚¯ã‚¨ãƒªã§ã¯ã€é«˜å“è³ªã®ã‚¯ã‚¨ãƒª ãƒ—ãƒ©ãƒ³ã«å¿…è¦ãªçµ±è¨ˆãŒã‚¯ã‚¨ãƒª ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãƒ¼ã«ã‚ˆã£ã¦æ—¢ã«ç”Ÿæˆã•ã‚Œã¦ã„ã¾ã™ãŒã€æœ€é©ãªçµæžœã‚’å¾—ã‚‹ãŸã‚ã«è¿½åŠ ã®çµ±è¨ˆæƒ…å ±ã‚’ä½œæˆã—ãŸã‚Šã€ã‚¯ã‚¨ãƒªã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’å¤‰æ›´ã—ãŸã‚Šã™ã‚‹å¿…è¦ãŒã‚ã‚‹å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€çµ±è¨ˆã®æ¦‚å¿µã«ã¤ã„ã¦èª¬æ˜Žã—ã€ã‚¯ã‚¨ãƒªæœ€é©åŒ–ã®çµ±è¨ˆã‚’åŠ¹æžœçš„ã«ä½¿ç”¨ã™ã‚‹ãŸã‚ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’æä¾›ã—ã¾ã™ã€‚ ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆãŠã‚ˆã³æ¦‚å¿µ çµ±è¨ˆ ã‚¯ã‚¨ãƒªæœ€é©åŒ–ã«é–¢ã™ã‚‹çµ±è¨ˆã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä»˜ããƒ“ãƒ¥ãƒ¼ã® 1 ã¤ã¾ãŸã¯è¤‡æ•°ã®åˆ—ã®å€¤ã®åˆ†å¸ƒã«é–¢ã™ã‚‹çµ±è¨ˆæƒ…å ±ã‚’æ ¼ç´ã™ã‚‹ãƒã‚¤ãƒŠãƒª ãƒ©ãƒ¼ã‚¸ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ (BLOB) ã§ã™
xai1981 2018/07/26
sql_server

reference

index
ãƒªãƒ³ã‚¯
sys.dm_db_stats_properties (Transact-SQL) - SQL Server
é©ç”¨å¯¾è±¡: SQL Server Azure SQL Database Azure SQL Managed Instance ç¾åœ¨ã® SQL Server ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®æŒ‡å®šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ (ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ãŸã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä»˜ããƒ“ãƒ¥ãƒ¼) ã®çµ±è¨ˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’è¿”ã—ã¾ã™ã€‚ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ã¯ã€åŒæ§˜ã® sys.dm_db_incremental_stats_propertiesã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ æ§‹æ–‡ sys.dm_db_stats_properties (object_id, stats_id) å¼•æ•° object_id çµ±è¨ˆã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ãŒè¦æ±‚ã•ã‚ŒãŸã€ç¾åœ¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«ã‚ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® ID ã§ã™ã€‚ object_ID ã¯ intã§ã™ã€‚ stats_id æŒ‡å®šã•ã‚ŒãŸ object_idã®çµ±è¨ˆæƒ…å ±ã® ID ã§ã™ã€‚ çµ±è¨ˆ ID ã¯ã€ sys.stats å‹•çš„ç®¡ç†
xai1981 2018/07/26
sql_server

reference

index
ãƒªãƒ³ã‚¯
DO's&DONT's #8: ã‚„ã£ã¦ã¯ã„ã‘ãªã„ã“ã¨ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰ (REBUILD) å¾Œã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±æ›´æ–° (UPDATE STATISTICS)
ç¥žè°· é›…ç´€ SQL Server Escalation Engineer DO's&DONT's #7: ã‚„ã‚‰ãªã„æ–¹ãŒã„ã„ã“ã¨ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰ (REBUILD) å¾Œã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«åœ§ç¸® (SHRINK) ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰å¾Œã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åœ§ç¸®ã‚’è©±é¡Œã«ã—ã¾ã—ãŸãŒã€ä¼¼ãŸã‚ˆã†ãªã‚‚ã®ã¨ã—ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰å¾Œã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµ±è¨ˆæƒ…å ±æ›´æ–°ãŒã‚ã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰å¾Œã«ã€å†æ§‹ç¯‰ã—ãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®çµ±è¨ˆæƒ…å ±ã‚’æ›´æ–°ã™ã‚‹ã¨ã€ãã‚Œã¯æ„å‘³ãŒãªã„ã‹ã€çµ±è¨ˆæƒ…å ±ã®ç²¾åº¦ã‚’è½ã¨ã—ã¾ã™ã€‚ ãªãœï¼Ÿ DO's&DONT's #7: ã‚„ã‚‰ãªã„æ–¹ãŒã„ã„ã“ã¨ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†æ§‹ç¯‰ (REBUILD) å¾Œã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«åœ§ç¸® (SHRINK)Â ã§ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†æ§‹ç¯‰ã«ã‚ˆã‚Šã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å†ä½œæˆã•ã‚Œã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå†æ§‹ç¯‰ã•ã‚Œã‚‹æ™‚ã€åŒæ™‚ã«ãã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®çµ±è¨ˆæƒ…å ±ã‚‚ä½œæˆã•ã‚Œã¾ã™ã€‚ã“ã“ã§ä½œæˆã•ã‚Œã‚‹çµ±
xai1981 2018/07/20
sql_server

index

tuning
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä¸è¶³ã‚’èª¿ã¹ã‚‹ - ã¶ã‚Šã‚Šã‚ã‚“ã¨ã‚ãƒ¼ã©(ä»®)
sys.dm_db_missingå‹•çš„ãƒ“ãƒ¥ãƒ¼ã‚’ç”¨ã„ã‚‹ã¨ä¸è¶³ã—ã¦ã„ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‹ã‚‹ã€‚ ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã§ç‰¹ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä¸è¶³ã—ã¦ã„ã‚‹ã¨æŽ¨æ¸¬ã•ã‚Œã‚‹ã‚‚ã®ã‚’æŽ¢ã™SQLã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ SELECT TOP 10 [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) , avg_user_impact , statement AS ãƒ†ãƒ¼ãƒ–ãƒ«å , equality_columns as ç‰å·åˆ— , inequality_columns as ä¸ç‰å·åˆ— , included_columns as ä»˜åŠ åˆ— FROM sys.dm_db_missing_index_groups g INNER JOIN sys.dm_db_missing_index_group_
xai1981 2018/07/06
sql_server

index
ãƒªãƒ³ã‚¯
è©¦ã—ãŸã„ã‘ã©æ€–ãã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½œã‚Œãªã„ã¨ãã«ä»®ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã£ã¦ã‚¯ã‚¨ãƒªã®å‹•ä½œã‚’ãŠè©¦ã—ã—ã¦ã¿ã‚‹ - éƒ½å†…ã§åƒãSEã®æŠ€è¡“çš„ãªã²ã¨ã‚Šã”ã¨ / Technical soliloquy of System Engineer working in Tokyo
ã€ŽSQL ã®å®Ÿè¡Œæ™‚é–“ãŒé…ãã€èª¿æŸ»ã—ãŸã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä¸è¶³ã—ã¦ã„ãŸã€é‹ç”¨ç’°å¢ƒã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ ã›ãã°ï¼ã‘ã©...ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¿½åŠ ã—ãŸãŸã‚ã«ä»–ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ãŒã§ã‚‹ã®ãŒæ€–ã„ï¼ã€ã¨ã„ã†ã“ã¨ã¯ã€SQL Server ã®é–‹ç™ºã«æºã‚ã£ã¦ã„ã‚Œã°èª°ã—ã‚‚çµŒé¨“ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚(ã‚‚ã¡ã‚ã‚“ã€ç§ã‚‚ãã®ä¸€äººã€‚) ãã®ææ€–ã‹ã‚‰ "å°‘ã—ã ã‘" è§£æ”¾ã—ã¦ãã‚Œã‚‹ã®ãŒã€ä»Šå›žç´¹ä»‹ã™ã‚‹ä»®æƒ³ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã™ã€‚ã¾ãšã¯ sys.indexes ã®å†…å®¹ã‚’å‚ç…§ã™ã‚‹ãŸã‚ã€ä¸‹è¨˜ã®ã‚¯ã‚¨ãƒªã‚’ SQL Server Management Studio ã‹ã‚‰å®Ÿè¡Œã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SELECT object_id, name, index_id, type_desc, fill_factor, is_hypothetical, allow_page_locks, allow_row_locks FROM sys.indexes ä¸Šå›³ã®é’æž éƒ¨åˆ†ã« ã€Ži
xai1981 2018/07/06
sql_server

tuning

index
ãƒªãƒ³ã‚¯
ä»˜åŠ åˆ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - ã¶ã‚Šã‚Šã‚ã‚“ã¨ã‚ãƒ¼ã©(ä»®)
SqlServerã§ã¯ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¬ ç‚¹ã‚’è£œã†ã‚‚ã®ã¨ã—ã¦ ä»˜åŠ åˆ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ ã¾ãšã€ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯éžã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¿œç”¨ã—ãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ é€šå¸¸ã®éžã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä¸»ã«æ¤œç´¢æ¡ä»¶ã«ä½¿ç”¨ã™ã‚‹é …ç›®ã«ã¤ã‘ã‚‹ãŒ SELECTã®åˆ—ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«å«ã‚ã‚‹ã“ã¨ã«ã‚ˆã‚Šã‚¯ã‚¨ãƒªã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†…ã ã‘ã§å®Œçµã™ã‚‹ã‚ˆã†ã—ã€ ãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æ¸›ã‚‰ã™æ‰‹æ³•ã®ã“ã¨ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªSQLã‚’ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§å‡¦ç†ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã€ SELECT col_1,col_2,col_3 FROM tbl_hoge WHERE col_3 = 'harada'CREATE INDEX idx1_hoge ON tbl_hoge(col_3,col_1,col_2)ä¸Šè¨˜ã®å ´åˆã€col_1,col_2ã¯æŠ½å‡ºæ¡ä»¶ã§ã¯ãªã„ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«å«ã‚ã‚‹ã“ã¨ã«ã‚ˆã‚Š ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†…ã ã‘ã§ãƒ‡
xai1981 2018/07/06
sql_server

tuning

index
ãƒªãƒ³ã‚¯
SQLServerã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã–ã£ãã‚Šã¨ã¾ã¨ã‚ã¦ã¿ãŸ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? #SQLServerã«ã¤ã„ã¦ SQLServerã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦å¦ã°ã›ã¦ã„ãŸã ãæ©Ÿä¼šãŒã‚ã‚Šã€ã‚‚ã®ã™ã”ãå‹‰å¼·ã«ãªã£ãŸã®ã§ã¾ã¨ã‚ã¾ã™ã€‚ ã¯ã˜ã‚ã« ä»–ã®DBã¨åŒæ§˜ã«SQLServerã«ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µã¯å˜åœ¨ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã€DBãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢ã‚’é«˜é€Ÿã«è¡Œã†ãŸã‚ã®ç´¢å¼•ã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ ã“ã‚ŒãŒã‚ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã™ã¹ã¦ã‚’æ¤œç´¢ã›ãšã«ç›®çš„ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç‰¹å®šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ä¾¿åˆ©ãªã—ãã¿ã§ã™ã€‚ SQL Serverã«ãŠã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç¨®é¡žã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ’ãƒ¼ãƒ—è¡¨ï¼ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã—ã®ãƒ†ãƒ¼ãƒ–ãƒ«ï¼‰ ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯
xai1981 2018/07/04
qiita

sql

tuning

index
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒåˆ†ã‹ã£ã¦ãªã„äººãŒéžå¸¸ã«å¤šã„ã€‚ ç¾å®Ÿã«ã‚ã£ãŸä¾‹ã§ã€60ã‚«ãƒ©ãƒ ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã€å‰ã‹ã‚‰3ã¤ãšã¤ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’20å€‹ä½œã‚‹ã¨ã‹ã€30ã‚«ãƒ©ãƒ ã‚’1ã¤ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã™ã‚‹ã¨ã‹ã€æ„å‘³ãŒåˆ†ã‹ã£ã¦ã„ãªã„äººãŒéžå¸¸ã«å¤šãã„ã¾ã™ã€‚ â€» è©³ã—ã„äººã¸ã€‚ã“ã“ã§ã¯ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ = B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨è€ƒãˆã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã€ãã®ã¾ã¾ã‚ºãƒãƒªã€Œç´¢å¼•ã€ã®ã“ã¨ã§ã™ã€‚ èº«è¿‘ãªä¾‹ã§ã¯ã‚«ãƒ©ã‚ªã‚±ãŒã‚ã‚Šã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ã‚«ãƒ©ã‚ªã‚±æœ¬ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ãƒªãƒ¢ã‚³ãƒ³ã§æŠ¼ã™ç•ªå·ãŒä¸»ã‚ãƒ¼ã€æµã‚Œã‚‹éŸ³æ¥½ãƒ»æ˜ åƒãŒå®Ÿãƒ¬ã‚³ãƒ¼ãƒ‰ã¨è€ƒãˆã¦ã¿ã¦ãã ã•ã„ã€‚ ã‚«ãƒ©ã‚ªã‚±æœ¬ã¯ã€ŒæŒæ‰‹åé †ã€ã¨ã€Œæ›²åé †ã€ã®2ã¤ã¯æœ€ä½Žé™ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã¯ã€ æŒæ‰‹åé †ã¯ã€ã€ŒæŒæ‰‹åãƒ»æ›²åã€ã®çµ„ã¿åˆã‚ã›ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ æ›²åé †ã¯ã€ã€Œæ›²åãƒ»æŒæ‰‹åã€ã®çµ„ã¿åˆã‚ã›ã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€‚ ã¨è€ƒãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ æƒ³åƒã—ã¦ã¿ã¦ãã ã•ã„ã€‚å°å¦ç”Ÿã§ã‚‚ã€Œã‚¢ãƒ³
xai1981 2017/09/08
database

index
ãƒªãƒ³ã‚¯
ã€MySQLã€‘æ—¥ä»˜åž‹ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æ¤œè¨¼ã—ã¦ã¿ã¦ã®æ°—ä»˜ãã€‚ â€“ sawara.me
ãªã‚“ã‹æ—¥ä»˜ã‘åž‹ã®ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚ˆã†ã¨æ€ã£ãŸã‚“ã ã‘ã©ã€ã“ã‚Œã£ã¦ã»ã‚“ã¨ã«æœ‰åŠ¹ãªã®ï¼Ÿã£ã¦æ€ã£ãŸã®ã§ã€æ”¹ã‚ã¦æ¤œè¨¼ã—ã¦è¦‹ãŸã‚“ã ã‚ˆã¨ã„ã†è©±ã‹ã‚‰ã®æ°—ä»˜ãã€‚ çš†ã“ã‚Œå½“ãŸã‚Šå‰ã®æ§˜ã«çŸ¥ã£ã¦ã„ã‚‹ã®ã‹ãªãã€‚å°‘ãªã‹ã‚‰ãšåƒ•ã¯æ”¹ã‚ã¦æ°—ã¥ã„ãŸã®ã§ãƒ¡ãƒ¢ã¨ã—ã¦ã€‚ å‰ææ¡ä»¶ MySQL5.6 ä»¥ä¸‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ¤œè¨¼ç”¨ã«ç”¨æ„ã—ã¾ã™ã€‚æ¤œè¨¼ã™ã‚‹ãƒ‡ãƒ¼ã‚¿åž‹ã¯TIMESTAMPã¨DATETIMEã§ã™ã€‚ [sql] CREATE TABLE test (c1 INT NOT NULL AUTO_INCREMENT, c2 TIMESTAMP, c3 DATETIME, PRIMARY KEY(c1), KEY (c2), KEY (c3)) ENGINE InnoDB; INSERT INTO test (c2, c3) VALUES (â€˜2014-01-01 00:00:00â€™, â€˜2014-01-01 00:00:00â€™),
xai1981 2015/10/01
mysql

index
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸