Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2001-07-30 : 04:37:30
|
| Hi,I try to create index on view.I took care for all the previous neccessary conditions as mention in BOL.I got this error:" It contains one or more disallowed constructs."why ?thanksNoamNoam Graizer |
|
|
chmeyer
Starting Member
1 Post |
Posted - 2004-09-15 : 10:22:56
|
What do you think of Materialised views  |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-15 : 10:33:37
|
quote:
Originally posted by royv
Actually, izaltsman brings up a good point. I am considering creating indexes for a view, but was curious to know anyone else's experience with them. Is it worth it? Does it give the performance boost as with tables?
I found a massive performance boost with using indexed views, what I will suggest though is that you make the view as general as possible and be very careful with them in regards to which tables you add into the view... Had a lot of hassle to start with, but then generalised on what was required and once the frustration was over and I actually got to use them, a query that would take 3 minutes before only took about 10 seconds afterwards...Inserts and deletes will take much longer to any table used in the indexed view, if you need to update the data, it may be quicker to drop the index (and the view as it needs to be schemabound) before inserting and recreate it once the inserts/deletes are completed...As for the problem Noamg is experiencing, are you sure all the objects are schemabound?Can you possibly post your views code?? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-15 : 10:56:13
|
quote:
Originally posted by RickD
[quote]Originally posted by royv
As for the problem Noamg is experiencing, are you sure all the objects are schemabound?Can you possibly post your views code??
That's 3 years ago!  I hope they found a solution by now...Let's see...three years ago...the HEIGHT on the consultant era...IT is still paying.....Brett8-) |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-16 : 04:25:36
|
quote:
Originally posted by X002548
quote:
Originally posted by RickD
[quote]Originally posted by royv
As for the problem Noamg is experiencing, are you sure all the objects are schemabound?Can you possibly post your views code??
That's 3 years ago! I hope they found a solution by now...Let's see...three years ago...the HEIGHT on the consultant era...IT is still paying.....Brett8-)
Hahaha... I didn't look at the posted date... Why do people bring back old posts?? |
|
|
|
|
|
|
index on view