Quote Originally Posted by szlamany
Where CITYPE is NOT NULL

Is CITYPE an INDEX? And it allows NULL's? I'm not so sure how NULL's are handled in INDEX SCANS - I'm not sure I have ever indexed a column that allows null's...
CI_Type is not indexed.

I did find this:
how many rows in that table?
In the table where all the data is actually held there are 528,643 rows.