title: How to reduce clustered index scan cost by using SQL query
body: <p>How can I reduce the clustered index scan cost of below mentioned query</p>
  
  <pre><code>DECLARE @PARAMVAL varchar(3)
  
  set @PARAMVAL = 'CTD'
  select * from MASTER_RECORD_TYPE where RECORD_TYPE_CODE=@PARAMVAL
  </code></pre>
  
  <p>if I run the above query it was showing index scan 99 % </p>
  
  <p>Please find here below my table particularities:</p>
  
  <p><img src="https://i.stack.imgur.com/BvW0J.jpg" alt="enter image description here"></p>
  
  <p>here below i have pasted my index for the table:</p>
  
  <pre><code>CREATE TABLE [dbo].[MASTER_RECORD_TYPE] ADD  CONSTRAINT [PK_MASTER_REPORD_TYPE] PRIMARY KEY CLUSTERED 
  (
      [Record_Type_Id] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
  GO
  </code></pre>
  
  <p>kindly advise how can i reduce index scan cost?</p>