Theo Kramer wrote:
>
> Hi
>
> I have a single table with two views. The table effectively contains both
> master and detail info (legacy stuff I'm afraid). The query in question is
> used to see if any records exist in the detail that do not exist in the
> master. The table and index definition is as follows
>
> create table accounts (
> domain text,
> registrationtype char
> /* Plus a couple of other irrelevant fields */
> );
>
> create index domain_idx on accounts (domain);
> create index domain_type_idx on accounts (domain, registrationtype);
try using create index registrationtype_index on accounts (registrationtype);
------
Hannu