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>...[color=blue]
      > 1) Can stored procedures be used against views?[/color]

      Yes
      [color=blue]
      > 2) What are the main limitation or disadvantages of using views?[/color]

      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...