Hi All
I have the following table without any primary key and Index. This table contains more than 20 Million records. Hence the Select statement is very slow (more than 20 sec for a date range 2012-12-01 to 2012-12-31).
CREATE TABLE tblDataLog(
[DATE_TIME] [datetime] NOT NULL,
[5] [float] NULL,
[6] [float] NULL,
[7] [float] NULL,
[8] [float] NULL,
[9] [float] NULL,
[10] [float] NULL,
[11] [float] NULL,
[12] [float] NULL,
[13] [float] NULL,
[14] [float] NULL,
[15] [float] NULL,
[16] [float] NULL,
[17] [float] NULL,
[18] [float] NULL,
[19] [float] NULL,
[20] [float] NULL,
[21] [float] NULL,
[22] [float] NULL,
[23] [float] NULL,
[24] [float] NULL,
[25] [float] NULL,
[26] [float] NULL,
[27] [float] NULL,
[28] [float] NULL,
[29] [float] NULL,
[30] [float] NULL,
[31] [float] NULL,
[32] [float] NULL,
[33] [float] NULL,
[34] [float] NULL,
[35] [float] NULL,
[36] [float] NULL,
[37] [float] NULL,
[38] [float] NULL,
[39] [float] NULL,
[40] [float] NULL,
[41] [float] NULL
) ON [PRIMARY]
Please suggest me how to optimize this table.
Thanks.
Willington