Re: Query time difference

[Ofer Bechar]

Thanks a lot Rick!

The partitioning is for couple of things:

1. Almost every select from the table will be from the same partition. A cross partitions select will be very rare.
2. For future archiving purpose.

The explain plan did change when it became slow - when it was slow it used the complex index. I removed it and it is now fast every time. BTW - before the partitioning, this index was used and the query was fast (without the index it was slow, not THAT slow, but slow - 10-15 seconds).

I will try your suggestions to try and make it even better.

The query was generated by Hibernate.

Thanks again!