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 - 2003-10-31 : 07:52:45
|
| Rajesh writes "We have a huge table with somewhere around 120 attributes and 10 million rows as it contains data for lot of our Broker's .And there is no primary key however artificial key is there i.e. identity column. Now we have to partition that table to inhance performance please let us know how to use view partition in this case? Here data that have to partition is on the basis of broker but ofcourse it's not a primary key." |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-10-31 : 09:12:40
|
| Rajesh We need a little more info.You have a table with 120 fields, Where is your redundent data?Does it list details of the broker like his/her contact info that can be sub-tabled.How about account info, can that be seperated?Just a couple of examples.JimUsers <> Logic |
 |
|
|
Rajzmit
Starting Member
1 Post |
Posted - 2003-11-15 : 04:39:21
|
| Hi,Sorry for delay in reply..We have a single table with name daily_report with structure as belowdaily_report(report_id int identity,client_id int,broker_id int,acc_id int,daily_income float,.....100 more attributes)Now we have to partition that table on the basis of client_id and broker_id but my problem is how to use view partition in this case as this table have multiple rows on the basis of client_id,broker_id,acc_id and have no primary key. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-11-17 : 08:08:58
|
| You Have An Id field (report_id int identity) This Should be a Unique field that can be set as your primary Key.However I would suggest that you make this a relational database. Take the redundant info in this table and sub-table it.Example: Table - Client, Key field [client_id] Table – Broker, Key field [broker_id] JimUsers <> Logic |
|
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-11-17 : 09:25:58
|
| yeah. What Jim told, That's correct.":-) IT Knowledge is power :-)" |
|
|
|
|
|
|
|
|
Sql Server 2000