SAK }‘ŠÙ

SAK Streets ƒƒCƒ“ƒXƒgƒŠ[ƒg }‘ŠÙEƒJƒtƒF ˆê—— SAK Streets ŒŸõ
| VB | SQL | Perl | PHP | ASP | JSP | C | PC | HP | FAQ | ƒtƒŠ[ƒ\ƒtƒg |

SQL ƒ`ƒ…[ƒjƒ“ƒO•Ò4 - SQL ŽÀsŒv‰æ‰ðÍAANALYZEAƒRƒXƒgƒx[ƒX

Oracle ŒÅ—L‚Ì•”•ª‚ª‚ ‚é‚©‚à‚µ‚ê‚Ü‚¹‚ñBSQL-ServerAMDB ‚Å‚Í’ˆÓ‚Ì‚±‚ƁB

¡ƒRƒXƒgƒx[ƒXØ‚芷‚¦

  E’ʏíARDBMS ‚́Aƒ‹[ƒ‹ƒx[ƒX‚ÅŽÀsŒv‰æ‚𗧂ĂĂ¢‚邪Aƒf[ƒ^—Ê‚ðŠî‚É
    Å“K‚ÈŽÀsŒv‰æ‚𗧂Ă邱‚Æ‚ª‚Å‚«‚éB
    ‚±‚ê‚ðƒRƒXƒgƒx[ƒX‚ÆŒ¾‚¤B
    ’A‚µAƒRƒXƒgƒx[ƒX‚̓f[ƒ^—Ê‚ª‘啝‚É•Ï“®‚µ‚½ê‡Aí‚ÉŽè“®‚сƒ“ƒeƒi
    ƒ“ƒX‚µ‚È‚¯‚ê‚΂Ȃç‚È‚¢B
    (ƒAƒiƒ‰ƒCƒYƒRƒ}ƒ“ƒhAƒf[ƒ^ƒx[ƒXÅ“K‰»Aƒf[ƒ^ƒx[ƒXƒ`ƒ…[ƒjƒ“ƒO)

  Ecompute statistics ‚́A512KB ’ö“x‚̏¬‹K–͂ȃe[ƒuƒ‹‚ÅŒø‰Ê‚ª‚ ‚éB

analyze table sak.Žó’m compute statistics;

  Eestimate statistics ‚́A‘å‹K–͂ȃe[ƒuƒ‹‚ÅŒø‰Ê‚ª‚ ‚éB

analyze table sak.Žó’m estimate statistics sample 30 percent;

¡ƒ‹[ƒ‹ƒx[ƒXØ‚芷‚¦

  Eƒ‹[ƒ‹ƒx[ƒX‚É–ß‚·‚ɂ́AŽŸ‚̂悤‚É‚·‚éB

analyze table sak.Žó’m delete statistics;

¡ƒ‹[ƒ‹ƒx[ƒXAƒRƒXƒgƒx[ƒXŠm”F

  EŽŸ‚Ì–â‚¢‡‚킹‚ŁAƒRƒXƒgƒx[ƒX‚̏î•ñ‚ðŠm”F‚Å‚«‚éB
    î•ñ‚ª‹ó‚̃e[ƒuƒ‹‚̓‹[ƒ‹ƒx[ƒX‚Å‚ ‚éB

select table_name ƒe[ƒuƒ‹, num_rows ƒŒƒR[ƒh”, avg_row_len •½‹ÏƒŒƒR[ƒh’·,
  blocks Žg—pƒuƒƒbƒN” from user_tables
;

¡SQL ƒ`ƒ…[ƒjƒ“ƒO•ÒŽ‘—¿
¡SQL Šî‘bŽÀ’n•ÒŽ‘—¿
¡SQL Šî‘b•ÒŽ‘—¿
¡Oracle PL/SQL •ÒŽ‘—¿
¡PostgreSQL •ÒAJAVA ServletAJSP •ÒŽ‘—¿
¡MySQL •ÒŽ‘—¿
| VB | SQL | Perl | PHP | ASP | JSP | C | PC | HP | FAQ | ƒtƒŠ[ƒ\ƒtƒg |

SAK Streets ƒƒCƒ“ƒXƒgƒŠ[ƒg }‘ŠÙEƒJƒtƒF ˆê—— SAK Streets ŒŸõ



Copyright (C) 1999-2017 Y.SAK