I want to query this...
--> SELECT * FROM bbs ORDER BY ref desc, step ASC LIMIT 12;
this query doesn't refer the index that made by this query.
--> CREATE INDEX idx_bbs ON bbs (ref, step);
but, i change the query that "ref desc" to "ref asc".
then query refer the index, and i can see a result very fast. :-(
so, i want to view an result that one column ordered by ascending, and oterh column
ordered by descending using index.
what do i do?
how make an index?
==================================================
==================================================
�츮 ���ͳ�, Daum
��� ���� ���� E-mail �ּ� �Ѹ��ϳ�
������ �ѱ� �˻����� Daum FIREBALL
http://www.daum.net
