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
 Database Design and Application Architecture
 Nested Queries

Author  Topic 

JVisconti
Starting Member

47 Posts

Posted - 2009-09-22 : 09:07:55
I have one large query that calls about 10 sup queries. Is this really the best design for the main query or can it be broken down into a less resource heavy query?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-09-22 : 10:58:31
Hard to tell...you'd have to post the query to get some sensible answers. But people here have mad skills...you'd be surprised what performance you could squeeze out of just about anything.

- Lumbago
Go to Top of Page
   

- Advertisement -