A Couple of Questions on Views

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • MG
    #1

    A Couple of Questions on Views

    Hi,

    1) Can stored procedures be used against views?

    2) What are the main limitation or disadvantages of using views?


    Thanks,
    mohsen
    Tags: None
    • Tony
      #2
      Re: A Couple of Questions on Views

      deeplfo@yahoo.c om (MG) wrote in message news:<c8e3e11c. 0403022058.5da2 129d@posting.go ogle.com>...
      1) Can stored procedures be used against views?
      Yes
      2) What are the main limitation or disadvantages of using views?
      None, as long as you use common sense. For example, if you have a
      view based on the dept table with lots of joins to other tables,
      aggregate functions, calls to user-defined functions, etc. then it
      would be inadvisable to use it in a query like "select dname from
      my_view" if all you really needed was "select dname from dept".

        Comment

        • MG
          #3
          Re: A Couple of Questions on Views

          Thanks Andrew.

          Mohsen

            Comment

            • MG
              #4
              Re: A Couple of Questions on Views

              Sorry, meant to write Tony :-)

                Comment

                Previous template Next
                Working...