which is faster Subqueries or Views?

		Wrox Programmer Forums > Database > SQL Language
which is faster Subqueries or Views?

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 1st, 2008, 11:20 PM

lakshminal lakshminal is offline

Registered User

Join Date: May 2008

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

which is faster Subqueries or Views?

i have written sql statements in one project. but server performance is slow. now i have to improve the server performance. my plan is write the views instead of subqueries . which is better subqueries or views.
please give me suggestion for above problem.
my database is db2/400

nallappa

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SubQueries	debbiecoates	SQL Server 2000	5	October 22nd, 2007 02:04 PM
Multiple subqueries?	thf1977	MySQL	1	October 24th, 2006 05:30 PM
Trouble with Subqueries, am I going mad.	kim3er	SQL Server 2000	3	April 10th, 2005 02:13 PM
converting Access 2000 views to Sql views	matta	Classic ASP Professional	1	January 26th, 2005 03:37 PM
subqueries	mgdts	SQL Server DTS	0	July 28th, 2003 01:13 PM