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 |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2000-11-06 : 12:50:10
|
| I have found that Stored Procedures are not faster in many cases.Especially on complex queries that use inner joins and the like.I have recently come across info where other developers have found the same thing. However they claim in SQL 6.5 Storeds were faster across the board and 7.0 is where it slowed down.The next thing I am going to try is indexing data to see if that helps. I notice the numeric identity primary keys are already indexed however I can not see where this is of much benefit since number order means little in relation to alpha order. Dig?Should I leave the index on the identity numeric fields and then add an index to the column/columns I am most concerned with? Experienced Indexers are encourage to give knowledge :)Thanks gang.R |
|
|
|
|
|
Stored Procedures are not faster in a lot of cases