I have a table in SQL Server 2008 with 553,386 rows and every day it is increasing by about 400 rows. Now when I full scan of the table (
Select * from) it is taking 23 sec. Is there any solution to speed up the query?
My PC configuration is, CPU: Intel Core 2 Duo 2.0 GHz, RAM: 4GB, OS: Windows 7 32 bit
Thanks in advance!
Table structure is given below:
USE [dbCPFL_Test] GO /****** Object: Table [dbo].[PriceData] Script Date: 10/04/2013 19:56:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PriceData]( [TradeDate] [date] NOT NULL, [Ticker] [varchar](50) NOT NULL, [ClsPRC] [float] NOT NULL, [No_of_Share] [float] NOT NULL, [TradeStatus] [char](1) NOT NULL, [Adj_MKTCap] [float] NOT NULL, [deList] [char](1) NOT NULL, CONSTRAINT [PK_PriceData] PRIMARY KEY CLUSTERED ( [TradeDate] ASC, [Ticker] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO