Subject Re: [firebird-support] View or select? (Performance question)
Author Martijn Tonies
> 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
My thoughts:
Database development questions? Check the forum!