I have a large table with more than one million rows and give me a group of data to return this table In the shortest time you will have to ask. So I have created a test environment with this table definition: create table [dbo]. [Test] (NIM), [Dim1ID] [nvarchar] (20) No NULL, [Dim2ID] [nvarchar] (20) No NULL, [Dim3ID] [nvarchar] (4) No NULL, [Dim4ID] [smalldatetime] NULL, Dim5ID] [nvarchar] (20) No zero, [Dim6ID] [nvarchar] (4) No NULL, [Dim7ID] [nvarchar] (4) No NULL, [Dim8ID] [nvarchar] (4) No NULL, [Dim9ID] [Nvarchar] (4) No NULL, [Dim10ID] [nvarchar] (4) No NULL, [Dim11ID] [nvarchar] (20) No NULL, [value] [decimal] (21, 6) No NULL, obstacle [PK_Test ] Primary key cluster ([Dim1ID] ASC, [Dim2ID] ASC, [Dim3ID] ASC, [Dim4ID] ASC, [Dim5ID] ASC, [Dim6ID] ASC, [Dim7ID] ASC, [Dim8ID] ASC, [Dim9ID] ASC, [Dim10ID] with ASC, [Dim11ID] ASC (PAD_INDEX = closed, STATISTICS_NORECOMPUTE = closed, IGNORE_DUP_KEY = off, ALLOW_ROW_LO [primary]] [primary] This table is the actual table o...