How to enable index seek with this case

• nguyennd

  SSCommitted

  Points: 1881

  More actions

  March 2, 2010 at 11:07 pm

  #211793

  Table

  CREATE TABLE [dbo].[A](

  [K] [int] NOT NULL,

  [V] [varchar](50) NOT NULL,

  CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED

  (

  [K] ASC,

  [V] ASC

  )

  http://unitech.vn

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 3, 2010 at 8:27 am

  #1127821

  --- Duplicate thread ---

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi