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 |
|
dipeshneema
Starting Member
6 Posts |
 Posted - 2010-11-30 : 01:23:10
|
| I have one table which will have around 15million records. I currently have 50 columns in it. I have full text search enable on 6 columns. I need to use order by and group by also in the query.for the performance purpose what will be the better choice keeping structure same or split it into two tables.Quick Reply will be very helpful.Thanks in advance |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-11-30 : 08:12:35
|
| If you have decent hardware 15 mill records should not be a problem at all. Keep the same structure would be my default advice...but to give a more qualified answer you'd have to provide more details about the data in this table and how it will be queries.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
Need help on Table Creation