Re: [SQL] view and performance

2001-07-07 Thread Richard Huxton
From: "Wei Weng" <[EMAIL PROTECTED]> > Is there any gain on performance if you choose to create a view over a > very complex query instead of running the query itself directly? I *believe* views are pre-parsed so you gain that time. Can't believe you'd notice much difference either way unless th

[SQL] view and performance

2001-07-06 Thread Wei Weng
Is there any gain on performance if you choose to create a view over a very complex query instead of running the query itself directly? Thanks! -- Wei Weng Network Software Engineer KenCast Inc. ---(end of broadcast)--- TIP 4: Don't 'kill -9' t