How to minimize time of executing select from view?

[maxim]

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

[chrisrlong]

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

[gregdba]

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.