clarencen/lshift — Issue #30: Composite index on diffs table
Author: clarencen
Created: 2011-11-14 22:41:26+00:00
State: open

The query

@@@
select max(reporteddi0_.seq_id) as col_0_0_ from diffs reporteddi0_ where reporteddi0_.domain=:1
@@@

is doing a full table scan (Cost 3027). There is an index on seq_id but because of the domain predicate it doesn’t help. What would probably help is a composite index on domain and seq_id.