SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Temp Table Or View..
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sonu619
Posting Yak Master

195 Posts

Posted - 02/21/2013 :  00:10:58  Show Profile  Reply with Quote
Hi Guys,

I am having a problem with my SP, taking extra time to execute. I am using VIEW that has I believe 334k rows. I am wondering what do you guys think its a good idea if i create #temp table and Create Index On it and use this temp table all over Instead of View. I can't create index on View.

Do you guys think its improve the performance or worse.

Any advise?

Thanks in advance...

bandi
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 02/21/2013 :  01:04:07  Show Profile  Reply with Quote
It depends on your operations ...
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2fd2dc91-3fce-481e-a82b-1f1e0048b1d2/

--
Chandu
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000