Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
panayiotis
Starting Member
16 Posts |
 Posted - 2007-11-16 : 21:58:43
|
| Hello,I have a table which when i execute a select statement the execution lucks performance. The table currently has 1000 rows.Table:CREATE TABLE [dbo].[Listings]( [ListingID] [int] NOT NULL, [UserID] [int] NOT NULL, [NodeID] [int] NOT NULL, [Title] [varchar](100) NOT NULL, [Description] [varchar](500) NOT NULL, [Keywords] [varchar](200) NOT NULL, [URL] [varchar](150) NOT NULL, [DateSubmited] [datetime] NOT NULL) ON [PRIMARY]Even a simple sql statement without any where clause will take 3 seconds to execute. select LISTINGID, TITLE, DESCRIPTION from listingsIs there anyway to improve that?Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:20:45
|
| What kind of hardware? Did you check disk i/o? |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-17 : 01:31:36
|
| Create appropriate indexes and restrict your queries for better performance. Otherwise you are looking at a table scan which is the worst case.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Select Performance