mysql²»ÄÜÕýÈ·µÄʹÓà ÁªºÏË÷Òý
ÔÚÒ»¸ö±íÉÏÓÐ2¸öÁªºÏË÷Òýy(a,b,c),x(a,c) ÎÒ²éѯµÄʱºò select * from table where a=1201 order by c desc limit 20 µÄʱºòÓÃexplain²é¿´£¬·¢ÏÖmysqlÓõÄÊÇyË÷Òý ÕâÑùÎÒÔÚextraÀï¿´µ½ÓÐfilesort,¶ø²»ÊÇÎÒÏëÒªµÄxË÷Òý£¬Õâ¸öÔõô°ì£¿Ôõô²ÅÄÜÓõ½ÎÒµÄxË÷Òý
select * from table FORCE INDEX (x) where a=1201 order by c desc limit 20 ʹÓà Index Hint Ïê¼ûMYSQL¹Ù·½ÊÖ²á MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html ok,ÎÒ·¢ÏÖÓеÄʱºòÊÇʹÓÃxË÷Òý£¬ÓеÄʱºòÊÇy ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÒòΪÕâ¸ö±íµÄÊý¾ÝÏÖÔÚ´ó¸ÅÓÐ 200¶àw,¹À¼ÆÒÔºó»¹»á¶à£¬ÓÃÁËfilesort¸Ð¾õºÜÂýÒýÓà ok,ÎÒ·¢ÏÖÓеÄʱºòÊÇʹÓÃxË÷Òý£¬ÓеÄʱºòÊÇy ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÌṩÄãµÄ show create table xxxx; show index from xxxx; explain select * from table where a=1201 order by c desc limit 20 | tb_goods | 0 | PRIMARY | 1 | iid | A | 2350642 | NULL | NULL | | BTREE | NULL | | tb_goods | 1 | cid_total | 1 | cid | A | 5366 | NULL | NULL |
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......