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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2008-01-11 : 15:49:37
|
| Hi,Say I have a database with 20 columns, and when I grab data from the tables via my SELECT statements, I do it like so:SELECT c1, c2...c10andSELECT c11, c12...c20Now say the table has 1 million rows in it, would it theoretically speed things up if I split the tables into 2? (Table#1 c1-c10 and Table#2 c11-c20). |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-11 : 16:41:02
|
| Not necessarily. It depends on your SQL queries. You can have 1 mill or 100 mill rows and 20 columns. SQL Server can easily handle that. It comes down to how optimized your query is.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-12 : 00:17:01
|
| What happens if you need c1, c12, ...? Have to do join. |
|
|
|
|
|
|
Splitting up tables, performance benifit?