|
Home > Archive > MS SQL Server > July 2005 > Indexed view slow update
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Indexed view slow update
|
|
|
| Hi,
I have a few index views and it's very slow to update the base tables. It
was expected that it would be slow but I didn't expect it to be that slow
(>1 min). There are many columns in my view and many rows as well. My app
gets timed out because it can't wait. Is there anything I can do to help
speeding up the update of the base tables?
thanks for your help!
| |
| P.Ruello 2005-07-22, 7:23 am |
| Hello,
Perhaps your tables have clustered indexes.
Hope this will help.
Best regards
--
P.RUELLO
DBA
"Zeng" wrote:
> Hi,
>
> I have a few index views and it's very slow to update the base tables. It
> was expected that it would be slow but I didn't expect it to be that slow
> (>1 min). There are many columns in my view and many rows as well. My app
> gets timed out because it can't wait. Is there anything I can do to help
> speeding up the update of the base tables?
>
> thanks for your help!
>
>
>
| |
| P.Ruello 2005-07-22, 7:23 am |
| hello,
Perhaps that your tables have clustered indexes.
Hope this help
--
P.RUELLO
DBA
"Zeng" wrote:
> Hi,
>
> I have a few index views and it's very slow to update the base tables. It
> was expected that it would be slow but I didn't expect it to be that slow
> (>1 min). There are many columns in my view and many rows as well. My app
> gets timed out because it can't wait. Is there anything I can do to help
> speeding up the update of the base tables?
>
> thanks for your help!
>
>
>
|
|
|
|
|