<aside> ⚙️

</aside>

1. FULL SCAN

select count(*) from product where product_name like '%블루베리%';
select count(*) from product where product_name like '%안드로이드%';
select count(*) from product where product_name like '%청바지%';
select count(*) from product where product_name like '%여름%';

• 인덱스를 생성하지 않은 채로 검색어 일치 상품을 조회하면 Full Scan으로 테이블 전체를 읽어 데이터를 탐색한다.

• Full Scan 성능 테스트 결과

2. B-TREE INDEX

select count(*) from product where product_name like '블루베리%';
select count(*) from product where product_name like '안드로이드%';
select count(*) from product where product_name like '청바지%';
select count(*) from product where product_name like '여름%';