| Converting Non-Partitioned table to Partition table [message #196782] |
Sat, 07 October 2006 05:25  |
himang
Messages: 282
Registered: March 2005
Location: Bangalore
|
Senior Member |
|
|
Hi Experts,
Is there a direct way to change a non-partitioned table to a partition one?
We have one problem, currently in production in which a table (non-partitioned) in which many concurrent INSERT requests happen through WINDOWS service and sometimes the ENQUEUE wait are too high. What we are planning is to HASH partition the table. Is there any way where we can directly create partitions in the table?
The option we are looking at is:
1. Create an empty HASH partitioned table.
2. Transfer the records from existing table to new partitioned table and then drop the old one and rename it.
Is there a better way to do this? As we have 4,00,000 records in table and pushing in to temp table might take some time and result in more downtime.
Also, how can I find out how many CONCURRENT INSERT request are happening on any given table?
Regards
Himanshu
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
