We have an application (developed for us) which relies heavily on nested views. So if the "main" (lets call it A) view looks at another view (B) where if B is opened it does a full table scan, does that mean when A is ran with a criteria it needs to let B do a full table scan first and produce all the results to hand to A ?
If the view has indexes does that make it any different ?