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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-08-06 : 02:07:03
|
| Dear experts,I've been working for an ERP solutions, company, as a DBA....we have around 1200 tables as wellas 650 views.....we are not using clustered index on views.....using the clustered index will boost the performance? and the ERP is web based application. so that modifications will be done on a regular basis....is it good thing to implement clustered indexes on these views....please guide me in this regardthank you verymuchVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-08-06 : 05:02:57
|
| Our product has 1200 tables as well as 650 views...we will customise the product according to their requirements, and install them.is it a better idea for the product to put indexes on views?..................i don't know whether i need to provide more information or ................i'm not getting any repliesVinodEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-06 : 12:01:26
|
| Depends. You can speed up selection from indexed views, but will slow down update processes on underlying tables. YOu have to do some benchmarking to decide if it's good for your app or not. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-08-06 : 12:18:54
|
| Step 1: Optimize your SQLStep 2: Make sure all underlying tables are indexed properlyStep 3: Consider indexed ViewsBe sure that steps 1 & 2 are completed thoroughly and properly before even thinking about step 3.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
regarding indexed views