• In theory, non-indexed views are supposed to be broken down into their component pieces and eventually reassembled as a huge nested query.

    In reality, those huge nested queries, even when directly written, rarely behave as planned. Couple this with aggregation subqueries, extraneous data and joins, and any other number of concerns and view nesting can be very problematic. In general, I recommend you create views only for very common requests and try to avoid significant nesting.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA