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 |
|
hakim
Starting Member
11 Posts |
 Posted - 2002-10-25 : 15:07:50
|
| Hi all,Is there a way to make partition on a table(Like in Oracle)based on a key to improve performance.Thanks in advance |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-10-25 : 15:10:11
|
| You could create federated databases/distributed partitioned views in SQL Server 2000. SQL Server Books Online has more informaiton on this topic. Here's a basic introduction:What are federated databases?http://vyaskn.tripod.com/what_are_federated_databases.htm--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
Table partition