-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|