Hi,

I could solve the problem. Inside the subselect there was an inline function which prevent the parallel processing. I put this function in front of the insert into a variable...

No, there aren"t any other indices

But can you explain me why a parallel insert and delete in two different Partition works meanwhile a parallel insert in the Same partitions will be blocked ?

This behaviour should...

Hi,

the listed insert statement is only an example. The mentioned subselect is in reality more complex. So I've only simplified it.

Yes perhaps it could work over the indirect way...

Hi,

thanks a lot for your tips. I've decided to change the sequence of the jobs of each parallel process, so I could also minimize the locks.

But I have still...

I think this solution doesn't help me. Because a switch partition leads to a Schema-M lock. And if all of my parallel processes wants a schema-m lock nothing works anymore.

I...

Hi,

most of the tables are partionend by our StoreId. In sum we have 6 stores (1,2,...6), so 6 partitions per table. And all our stored procedures have a input-parameter StoreId...

Yes you're right. The most locks occur by the merge statements. Do you have an idea how to prevent it?

So can you also give me some hints what i have...

Hi Koen,

thanks for the fast answer. But is there no other chance to load the table at the same time? Because i thought that because of the partioned tables that...