IT/DB2018. 1. 27. 18:40Index Scan vs Index Seek

출처 : http://blog.naver.com/PostView.nhn?blogId=waws01&logNo=60181424769&redirect=Dlog&widgetTypeCall=true ★ Best 실행계획은 Clustered Index Seek (Clustered) 이다!!! ====================================================================================CREATE TABLE tmp_myfan( fan_id INT NOT NULL -- 고유값 , fan_name NVARCHAR(20) NOT NULL -- 날조아하는여학생명 , fan_feel FLOAT NOT NULL DEFAULT 0 -- 호감지수 , fan_gift NVAR..

image