<aside> <img src="notion://custom_emoji/8724d7dc-093a-4b2a-91be-6fc5fe70f494/1c2b3ff4-1d39-801f-b13d-007aedab7910" alt="notion://custom_emoji/8724d7dc-093a-4b2a-91be-6fc5fe70f494/1c2b3ff4-1d39-801f-b13d-007aedab7910" width="40px" />

https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html

https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html

https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html

https://velog.io/@juhyeon1114/MySQL-검색-성능-개선하기-like와-full-text-search

https://velog.io/@dl-00-e8/MySQL-Full-text-search-도입

https://yurimy.tistory.com/48 https://velog.io/@juhyeon1114/MySQL-Index의-구조-B-Tree-BTree https://zorba91.tistory.com/293 https://velog.io/@swager253/Yunny-bucks.-Full-Text-Search-성능-개선

https://inpa.tistory.com/entry/MYSQL-📚-풀텍스트-인덱스Full-Text-Index-사용법

</aside>

인덱스 설계 계기

%LIKE% 연산의 문제점

FULLTEXT INDEX가 어떻게 굴러가는지 알아보자

테스트 데이터로 FULLTEXT INDEX를 사용해보자