Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Post Unanswered: when is the data put in the view???

    could any body tell me when is the data brought /put in the view???what i know that Oracle never physically stores the data in the view...
    It basically stores the SQL statement that creates the view..so how is it that when we are selecting the data we see it from the view??
    Regards......
    Chiranjib...

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    62
    when you select data from the view, the query used to create the view is fired at backgroung and you get the data.
    As the query is stored in the database and compiled at the time of creation of view, it takes less time than the query you fire directly.
    Regards,

    Rushi

  3. #3
    Join Date
    Jan 2004
    Posts
    37
    and is it that data of that query is buffred somewhere till the session continues...????

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    62
    It is like any normal query. You Fire it and you get the results.
    The major difference is the query used to create the vire is parsed and stored in the database. So Oracle does not have to parse it when you select data from the view.
    Regards,

    Rushi

  5. #5
    Join Date
    Jan 2004
    Posts
    37
    thanx rushi ....i got it....

  6. #6
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    unless of course its a materialised view, in which case the data returned by the view is stored in the db.
    Regards
    Dbabren

Posting Permissions

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