tuningproblem : materialized table instead of view

[bdjensen]

Hi!
I have an select on a view that takes too much time. The view include joins.
I tried index-analysis and explain-plan, but this don't help.

But it helped when making a real table (select * into realtable from
bigview) and afterwards
making my select on realtable...?

Suggestions? Where to read more about it?
Greetings
Bjørn

[Simon Hayes]

"bdjensen" <b.***************@gmx.net> wrote in message
news:41*********************@dread14.news.tele.dk. ..

Hi!
I have an select on a view that takes too much time. The view include
joins.
I tried index-analysis and explain-plan, but this don't help.

But it helped when making a real table (select * into realtable from
bigview) and afterwards
making my select on realtable...?

Suggestions? Where to read more about it?
Greetings
Bjørn

There's a lot of information about performance tuning - you might want to
look into something like the MS Press Performance Tuning book, or sites like
this:

http://www.sql-server-performance.com/

In your specific case, it's impossible to say anything without information
about the view definition, table structures, indexes, data etc., and even
then it might be too complex to discuss in a newsgroup. If you use the view
a lot, you might consider indexing it - see "Creating an Indexed View" in
Books Online. But there are quite a lot of restrictions, and you get a
performance hit on any data modifications to the underlying tables, so it's
probably most useful in reporting, where the data doesn't change much.

Simon

[bdjensen]

Thanks!
I'll look at indexed views and try it ;-)
/Bjørn
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch...

"bdjensen" <b.***************@gmx.net> wrote in message
news:41*********************@dread14.news.tele.dk. ..

Hi!
I have an select on a view that takes too much time. The view include
joins.
I tried index-analysis and explain-plan, but this don't help.

But it helped when making a real table (select * into realtable from
bigview) and afterwards
making my select on realtable...?

Suggestions? Where to read more about it?
Greetings
Bjørn
There's a lot of information about performance tuning - you might want to
look into something like the MS Press Performance Tuning book, or sites

like this:

http://www.sql-server-performance.com/

In your specific case, it's impossible to say anything without information
about the view definition, table structures, indexes, data etc., and even
then it might be too complex to discuss in a newsgroup. If you use the view a lot, you might consider indexing it - see "Creating an Indexed View" in
Books Online. But there are quite a lot of restrictions, and you get a
performance hit on any data modifications to the underlying tables, so it's probably most useful in reporting, where the data doesn't change much.

Simon