Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    24

    Unanswered: Improve performance of view

    I have one view new_view generated using another view say base_view.
    That base view has been created using data from 3 tables.

    When I query the view new_view it takes lot of time. There are 2222 record that are retrived by that view.

    How I can improve the performance of new_view?
    Can you please help.


    --P J S

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Base upon the plethora of details provided & I can say with confidence that if you Read The Fine Manual below

    Contents

    that the solution will be intuitively obvious to you.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    in other words if you can't give us details of the underlying SQL for both views the best we can say is its on page 1128.

Posting Permissions

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