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