Results 1 to 3 of 3

Thread: material views

  1. #1
    Join Date
    Feb 2004
    Posts
    19

    Unanswered: material views

    hi
    is there any thing like material views.if so wat is the difference between a view and material view.

    thanks
    kiran

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    If you can think of a view as a saved query, you'd be about there. A view does not have data. A materialized view is like a standard view except that the data is stored in an actual table.

    JoeB

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    do a search to help yourself
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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