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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Need help in creating Table

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 table


kris
Go to Top of Page

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
Go to Top of Page

antony_dba
Starting Member

26 Posts

Posted - 2010-11-30 : 05:03:12
do you want query perfomance or data's

kris
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -