> I need to do several queries to a not-too-much changing dataset.
> Should I create a view and make queries over that view, or make a
> single select for each query? Statistically, which method is better?

If the optimizer is doing its job properly, it shouldn't matter.

I for one use views to abstract the business model from the actual
data storage or when I use the same query over and over again
in, for example, complex joins.



Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com