How to minimize time of executing select from view?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to minimize time of executing select from view?

  1. #1
    Join Date
    Feb 2001
    Posts
    35
    There is view with only 1000 records
    Select from view executes in 15 seconds
    Count (field.view) executes several minutes
    Help please to minimize time

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    You really need to provide a little more information than that.

    What is the view definition?
    What is the query you are running against the view?
    What is the explain plan?
    Indexes, tables sizes, and whatever other information you think might be useful

    - Chris

  3. #3
    Join Date
    Nov 2000
    Posts
    39
    If you are running 8.1.7, you can create materialized views and have a job runing to refresh them every so often. Materalized views contain actual data as opposed to regular views which only point to the tables.

Posting Permissions

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



Click Here to Expand Forum to Full Width