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
 General SQL Server Forums
 New to SQL Server Programming
 indexes

Author  Topic 

nandan
Starting Member

10 Posts

Posted - 2007-08-24 : 09:56:35
i am running a stored procedure which has got clustered indexes created after creating table and data is inserted into it after creating clustered indexes. The tables which are meant in this sp is temporary tables and how to gain the performance of a query

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-24 : 10:15:33
show us the query.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-24 : 23:08:21
And check execution plan.
Go to Top of Page
   

- Advertisement -