mysql join order by desc 속도..
본문
order by 를 뺴면 속도가 빠르게나옵니다...
order by 를 붙이기만하면.. 너무느려지네요....
alter table posts add index test11(is_page,read_level,space_no,no desc)
alter table space_access add index member_no(member_no)
select p.no
from posts as p use index(test11)
join space_access as s use index(member_no)
on s.member_no=2 and p.is_page = s.is_page and p.read_level = s.read_level and p.space_no=s.space_no
order by p.no desc
답변을 작성하시기 전에 로그인 해주세요.