DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. 05-15-2001, 06:31 AM #1
    maxim
    maxim is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 05-15-2001, 08:08 AM #2
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    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
    Reply With Quote Reply With Quote
  3. 05-15-2001, 08:40 AM #3
    gregdba
    gregdba is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width