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 - 2002-05-17 : 10:11:05
|
| Rudi writes "I need to know if it is possible to create an index over two or more files. Lets say I have file sql1 and sql2 which are the exact same format. I want a merged "file" that includes all info from both files that I can access to retrieve the data programatically. Also this index has to be updated with any updates to sql1 or sql2. I read your article about indexed views. Is this what i'm looking for? Also is possible to do this with sql1 in database1 and sql2 in database2?ThanxRudi" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-05-17 : 10:15:55
|
quote:
Rudi writes "I need to know if it is possible to create an index over two or more files. Lets say I have file sql1 and sql2 which are the exact same format. I want a merged "file" that includes all info from both files that I can access to retrieve the data programatically. Also this index has to be updated with any updates to sql1 or sql2. I read your article about indexed views. Is this what i'm looking for? Also is possible to do this with sql1 in database1 and sql2 in database2?ThanxRudi"
I think what you're looking for is called Distributed Partitioned Views and yes, it can be done. You can read up on them in Books Online. Basically you can create an Indexed View that spans multiple tables on multiple servers. You'll need SQL Server 2000 Enterprise Edition to make it work.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
|
|
|
Creating Indexes on more than one file or database