Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: Create views to improve performance?

    Hi,

    My web application need to query my database by joining many tables. The SELECT operation took very long. In some cases, it even time-out.

    I have tried creating views from the several tables but it don't seems to improve much performance.

    Does anyone has any better ideas??

    Pls help. Thanks..!

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    views don't improve performance.
    are your tables joined properly indexed are the indexes analyzed
    how looks the execution plan

  3. #3
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Hope this can help?
    http://www.billmagee.co.uk/oracle/sqltune/index.html

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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