February 12, 2008 at 11:50 am
I have a transactional table with abt 10 million rows. each time a web page is accessed , the table inserts a row with url accessed. occasionally we run reports also on this table to check data for specific date range. However this tabel doesnt have any clustered index or primary key. we have hevy performance issues when running any query against thsi table. Will it affect insert/updates if we add a clustered index to a table with this large vol of data. any help on this wil leb greatly appreciated.
TIA
February 12, 2008 at 12:01 pm
How many index do you have right now? You can only have one cluster index in one table, are you sure you do not have one cluster index now? Usually people use cluster index as the primary key.
February 12, 2008 at 12:05 pm
Hello Ishaan,
Yes it will have a slight performance hit when you are updating rather than inserting new rows in to the high volume table. One thing you can do is that the table can be partitioned which when queries are issued based on the date criteria will be having performance improvement as the queries will be hitting only the specific partition.
Hope this helps.
Thanks
Lucky
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply