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 |
|
vishalg
Starting Member
29 Posts |
 Posted - 2009-06-25 : 01:31:53
|
| Hello guys,I have one fundamental question about stored procedures and select statements. I have a stored procedure which i basically use for matching information in the database. Thus, in the stored proc I do a lot of select queries on a "view" i have created. Also, this stored procedure is goin to run over half a million of records.So my question is, will the select queries hamper my server's performance too bad??-Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-25 : 11:55:42
|
| Its not the "select" queries that will affect performance or the half million rows that you should be concerned about. You should be concerned about HOW the query is written, what indexes are available on the table(s), whether any of them help your queries etc.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-25 : 13:09:50
|
| you can very easy understand how the query is performing by looking into grpahical execution plan while executing the procedure and then decide on what indexes should be added to speed up retrieval process. |
|
|
|
|
|
|
a lot of select queries