January 31, 2013 at 7:28 am
Hi all,
In my database I have table with 24 crore records, I have a proper indexes on the table but still it is taking long time. Can any one provide the steps to handle large data table.
Is it possible to create table partition on primary file group DB.
Note: My Database is created with primary file group.
Thank's in advance.
January 31, 2013 at 7:51 am
If you have a query that is taking a long time, the first thing I'd suggest is taking a look at the execution plan to understand what it's doing on the server. That's going to tell you if it's using the indexes you have in place, and if not, it might help you understand why not.
Partitioning is first, and foremost, a data management tool, not a performance enhancer. It can help performance, but only if you can ensure that your queries will only go against a single partition. As soon as your queries cross partitions, performance is radically slower than having a single table.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply