I have read that using the SELECT column list INTO #tablename syntax to create temp tables holds locks in tempdb (create object locks) for the entire duration of the query.
If a typical query specifies both of the indexed columns, then you might want to try creating another index with the opposite key order to see whether a query that...