Re: Views

SaTriGuy wrote: > Basically all that a view does is to expand the query to include the view. So > there is no more actual overhead than if you had expanded your query to include > the definition of the view. > > Actually the view's definition is reduced to only include the items that are > necessary for the query being made. So if your query does not include some > items of the view, then those items are not needlessly processed. The problem is that Informix optimizator don't like to much tables with different size to be used in query ;) So views could be so much sophisticated so any other join would be tremendous slow :( BTW. Does some one know the _informix magical number_ of tables that could be used in joins most efficiently. (Some one told me that 3 is the right number) Sincerely, Alexander -- All opinions are my own and not those of my employer. -- | | Alexander V.Didytch, Kyiv, Ukraine, unknownthegreat@my-dejanews.com | -- -- -- -- -- --- Make sure they understand why it is needed. And let them figure out how to get it.-- Charles O.Holliday Jr. (DuPont CEO)