Re: Question: Performance of a view as opposed to a table

In general I would agree, however, the first time you access the view you will take a small hit as the engine executes the select statement that created the view. Has this changed w/ 7.23+?? -d SaTriGuy wrote in message <19980116210001.QAA08033@ladder02.news.aol.com>... >> What's the performance hit on selecting, deleting, inserting, etc. >>on a view compared to working with the table directly? This question has >>to do with views with no operation (e.g.: columnA - columnB) on columns, >>just straight selection. > >In 7.23 + the query against a view should have identical performace >characteristics as a query against the base tables. > >Madison Pruet