Re: SELECT query takes 5 secs, what can I do?

[Rick Hillegas]

Hi Andrew,

You might try adding more columns to your index so that it covers the 
whole WHERE clause:

CREATE INDEX IDX_Message_MessageId ON ExchangeSync.Message (messageId, 
archived, id)

Hope this helps,
-Rick



Andrew Bruno wrote:
Hello,

I have a query that used to take 10secs to run, i.e.

select * from Message m where
m.messageId='<7997716ed1af3d47a35d74fa2cb6109202553...@somedomain.com>'
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