OR between Regular and Metamorph searches SLOW

[skalyanaraman]

Hi,
We are running Texis version from OCT 28 2003.
We are running a count of all records with
"FIELD1 > '1000' and FIELD1 < '2000' or FIELD2 like 'test auto insurance @0'"
This select runs for more than 20 mins.
But, if I do FIELD2 like 'test auto insurance @0'
I get the count in less than minute,
and FIELD1 > '1000' and FIELD1 < '2000' comes back in less than a 5 seconds.

Could you help us with this? We have regular index on FIELD1 and metamorph inverted on FIELD2.

TIA!!

[mark]

Does it work better if you parenthesize?
(FIELD1 > '1000' and FIELD1 < '2000') or FIELD2 like 'test auto insurance @0'

[skalyanaraman]

That did not help. it probably took the same time.