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
 how to improve database performance?

Author  Topic 

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-12-09 : 06:35:41
Hi all ,

My query in my database i am using joins but somebody said using joins performance will be slow.

so how to improve database performance.

Thanks & Regards
RamaDevi.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-09 : 06:52:00
Add relevant index(es).



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-12-09 : 08:10:07
quote:
Originally posted by samsun125

My query in my database i am using joins but somebody said using joins performance will be slow.

Never speak to that person again.

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page
   

- Advertisement -