Thread: view and performance

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.

From: "Wei Weng" <wweng@kencast.com>

> 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 the query was very fast to execute.

- Richard Huxton