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:24:03
|
| 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 |
|
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-11-30 : 01:28:34
|
| when you splitting tables data begin to scattered int to two tables.so reterving any data you have to refer two tables.the data maynot be consistent.so use one tablekris |
 |
|
|
dipeshneema
Starting Member
6 Posts |
Posted - 2010-11-30 : 01:37:52
|
| I am returning around 15 fields , some are using in the order by , one in group by , 6 in full text search and 10in where clause |
|
|
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-11-30 : 05:03:12
|
| do you want query perfomance or data'skris |
|
|
|
dipeshneema
Starting Member
6 Posts |
Posted - 2010-11-30 : 05:44:37
|
| I want query performance but if table can be optimized for the query then it will great |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-01 : 01:09:07
|
| normalization is always a good practice.but if you have created proper indexes on the table your query performance will not go down. |
|
|
|
|
|
|
Need help in creating Table