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 |
|
Freddie
Starting Member
29 Posts |
 Posted - 2006-05-19 : 13:53:30
|
| Hello:i am trying to create an index on a view but i get the error message that the reference table was created with the option ANSI_NULLS set to off. Is there a way around this..?Thx |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-19 : 14:06:32
|
| In my experience indexes on views cause more problems with Application Code than they are worth.Can you work around this without having to put an index on the View?What problem are you trying to solve?Kristen |
 |
|
|
Freddie
Starting Member
29 Posts |
Posted - 2006-05-19 : 14:10:20
|
| Hi KristenI have a view with 280 fields, i only 127000 records but it's very slow...takes 3 minutes to retrieve data.thx |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-05-19 : 17:06:36
|
| Have you investigated that the underlying table(s) have appropriate indexes?Is this some big crosstab of sorts? 280 fields is a lot.Regarding your question, You'll just have to make sure that all the conditions for createing an index on the view are met.That means that you might have to recreate table(s) with the correct options set.rockmoose |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-19 : 18:00:57
|
| can you paste the select query here?May the Almighty God bless us all! |
|
|
|
|
|
|
indexes on views