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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-15 : 17:13:54
|
| David Ward writes "Hello,We run a database which you have never heard of and we are trying to utilize SQL Server 2000 as the database engine, rather than our own.Our database expects a delimited record when a query is issued. So, we imported a sample of a database table into SQL Server, then created a view which would return the equivalent record format back to the host. It contains ~100 columns on the SQL side, so our view returns a concatenated string with the proper delimiters.My question is whether it is possible to create an indexed view for this type of interface or whether we are relagated to table scans for everything we query from the view.Thanks in advance for your response,-dew" |
|
|
|
|
|
Views and Remote Databases