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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How can i improve performance

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2009-08-17 : 04:50:15
In my databse one tables is there it has nearly 20 columns
the table have 16 lacks records when tried to retrive data from
that table its taking more time,
the table have composit primarykey(with tree columns,these are varchar data types)there is no identity column
how can i improve performance?

Sachin.Nand

2937 Posts

Posted - 2009-08-17 : 07:35:31
Please post your table structure & the query to retreive those records.


PBUH
Go to Top of Page
   

- Advertisement -