Results 1 to 4 of 4

Thread: Views compiled?

  1. #1
    Join Date
    Oct 2003
    Posts
    41

    Question Unanswered: Views compiled?

    Are the views compiled?

    meaning is there a query tree generated when we create the view, just like a stored procedure? if yes, then in which database is it stored?

    TIA
    Rajesh

  2. #2
    Join Date
    Oct 2003
    Posts
    41
    Anybody knows?

  3. #3
    Join Date
    Oct 2003
    Posts
    41
    Are views compiled like stored procedure?
    ====================
    Rajesh

  4. #4
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120
    Why should they be compiled?

    They will become part of another query plan which is compiled at runtime. This way the whole query can be optimized.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •