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 |
|
sql_buddy
Starting Member
41 Posts |
 Posted - 2009-07-01 : 09:01:00
|
| In case of cluster index on view ,whenever a record is added in the base table than the cluser index is changed at the time of recored insertion in table. or in any of case can we have only non-cluster on views ,without having cluster index(case of view) |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-01 : 09:27:39
|
| Indexed view is stored on disk, it must contain a clustered index (rather than a nonclustered one). Modify the index to make it a clustered index. |
 |
|
|
sql_buddy
Starting Member
41 Posts |
Posted - 2009-07-01 : 09:40:49
|
| is there any other way,other than indexing to fasten searching on viewsbecause i can't create cluster index on view and without that non-cluster index is not feasible ,and i need to fasten search on view |
|
|
|
sql_buddy
Starting Member
41 Posts |
Posted - 2009-07-02 : 02:09:39
|
| can we create clustered index on view having xml as one of its columns |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-02 : 05:25:09
|
| http://msdn.microsoft.com/en-us/library/ms191497(SQL.90).aspx |
|
|
|
|
|
|
cluster index on view