°ü¸® ¾È³»¼­


Explain µ¥ÀÌÅÍÀÇ È¹µæ

SQL¹®¿¡ ´ëÇÑ Explian µ¥ÀÌÅ͸¦ ÃëµæÇϱâ Àü¿¡, Explain ±â´ÉÀ» È£ÃâÇÏ´Â ±ÇÇÑ ID¿Í µ¿ÀÏÇÑ ½ºÅ°¸¶¸¦ »ç¿ëÇÏ¿© Á¤ÀÇµÈ ÇÑ ¼¼Æ®ÀÇ Explain Å×À̺íÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. Å×À̺í ÀÛ¼º ¹æ¹ý¿¡ °üÇÑ Á¤º¸´Â Explain Å×ÀÌºí¿¡ ´ëÇÑ Å×À̺í Á¤ÀÇ¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

Explain Å×À̺í Á¤º¸ ĸÃÄ

ÀÏ´Ü À̵é Å×À̺íÀÌ Á¤ÀǵǸé, SQL¹®ÀÌ ÄÄÆÄÀϵǰí Explain µ¥ÀÌÅͰ¡ ¿äûµÉ ¶§ Explain µ¥ÀÌÅͰ¡ ĸÃĵ˴ϴÙ.

EXPLAIN SQL¹® ¶Ç´Â CURRENT EXPLAIN MODE ·¹Áö½ºÅÍ »ç¿ë¿¡ ´ëÇØ¼­´Â SQL ÂüÁ¶¼­ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ. BIND ¹× PREP ¸í·É¿¡ ´ëÇØ¼­´Â Command Reference ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.

Explain ½º³À¼¦ Á¤º¸ ĸÃÄ

Explain ½º³À¼¦ µ¥ÀÌÅÍ´Â SQL¹®ÀÌ ÄÄÆÄÀϵǰí Explain µ¥ÀÌÅͰ¡ ¿äûµÇ¸é ĸÃĵ˴ϴÙ.

EXPLAIN SQL¹® ¹× FOR SNAPSHOT ¶Ç´Â WITH SNAPSHOTÀý »ç¿ë¿¡ ´ëÇØ¼­´Â SQL ÂüÁ¶¼­ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ. BIND ¹× PREP ¸í·É¿¡ ´ëÇØ¼­´Â Command Reference ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]