Fastest Query Method - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Fastest Query Method

Author

Topic

Need2CSharp
Starting Member

9 Posts

Posted - 2007-10-11 : 12:06:50

Hi Guys,

I have a quick question, which might be a bit too broad. In any case, I have to start somewhere, so here it is:

I have a stored procedure that joins (left outer joins) eight tables. Is the use of joins the quickest way to return my results, or is there a better method/routine? Do you need more information to give an appropriate resonse? Please let me know.

FYI, the stored procedure was created using C# and deployed to my MSSQL 2005 server.

Thanks for your help!

Kristen
Test

22859 Posts

Posted - 2007-10-11 : 14:46:09

"Is the use of joins the quickest way to return my results, or is there a better method/routine?"

In the broad context that you have asked the question my answer would be : Yes

"Do you need more information to give an appropriate resonse?"

Given that you asked, I would need:

DDL for the tables; INERT statements for a few samples rows; Expected results; Query plan from the Query Optimiser; description of why that is unexpected / unacceptable.

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20to%20ask%20a%20question%20on%20SQL%20Team%20and%20get%20a%20quick%20answer

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources