Performance of very large SQL Server table with millions of rows

5 pts.
Tags:
Database design
SQL Server administration
SQL Server database
SQL Server maintenance
SQL Server performance
Very Large Databases
Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data modification (insert, update, delete) on any row in any table in the database will make the same operation on the relevant row in the Bigtable, so we have a lot of data modifications in this table, - Any query on any table will join Bigtable to get relevant data from the Bigtable. (so there will be a lot of joins to Bigtable MY QUESTION: is there a problem with such a design; What about performance, indexes ??

Answer Wiki

Thanks. We'll let you know when a new response is added.

Without more information about the schema of BigTable I’m not going to be able to give you a good answer.

If the values in the columns on BigTable will all exist for all the rows then it is probably an OK design. If the rows which have parents in TableA have different columns filled out than the rows whos parent is in TableB then it isn’t such a good design. In this case each parent table wshould have its own child table with only the needed columns included.

Have a table with millions of rows unto itself isn’t a problem.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following