Stephen Friedrich wrote:
> Here is the plan if I query the inherited table directly
> (which is not really possible to do with that stupid, inflexible
> hibernate framework):
>
> explain select this_.id as id1_0_, <more columns>
> from call_sources_10554 this_
> where this_.cdr_id = 10554
> order by this_.id asc
> limit 100;
I don't suppose changing it to:
ORDER BY this_.cdr_id, this_.id
does anything for you?
--
Richard Huxton
Archonet Ltd