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 |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-13 : 06:59:17
|
| I have a partitioned view, i can't create index on that because i used computaion (non deterministic) column. my doubt is whether the index i created on the tables involved in the partitioned view will be used or not. |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2001-12-16 : 06:29:03
|
quote:
I have a partitioned view, i can't create index on that because i used computaion (non deterministic) column. my doubt is whether the index i created on the tables involved in the partitioned view will be used or not.
Hi,Could u plz explain how can u create index view |
 |
|
|
sathishkumar
Starting Member
21 Posts |
Posted - 2001-12-16 : 23:15:46
|
| creating index view is same as normal view . but while creating the view you as to use schemabinding option. then create index using create index syntax. for the first question index of tables will be used if you not specifing Expand all option |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-17 : 09:54:42
|
| ...and all this is documented in Books Online also. Indexed views are only available with SQL Server 2000. |
|
|
|
|
|
|
index on table used in partitioned view