Hello, I have a query that used to take 10secs to run, i.e.
select * from Message m where m.messageId='<[email protected]>' and m.id != 933927 and m.archived=1 The Message table has around one million rows. I added the following index CREATE INDEX IDX_Message_MessageId ON ExchangeSync.Message (messageId) and now it takes 5secs. Is there anything else I can do? Should I add an index on the boolean "archived" column too? Any performance hints appreciated. Thanks Andrew
