[SQLP] SQL SERVER 쿼리 힌트
-- 테이블 FULL 스캔하도록하는 힌트select * from test.emp with(index(0));실행계획select * from test.emp with(index(0)) |--Clustered Index Scan(OBJECT:([master].[TEST].[EMP].[EMP_PK])) -- EMP_PK : EMPNO-- pk 인덱스를 타게하는 힌트select * from test.emp e with(index(1)) where empno = 100; -- 테스트상 pk가 1번select * from test.emp e with(index=emp_pk) where empno = 100;select * from test.emp e with(index(emp_pk)) where empno = 1..