Skip to content
Advertisement

Indexing (x 4 OR y 5)

I am searching for an index to make the following quick:

The query is a delete and reads:

so it deletes all rows that do not match a few hundred criteria on t1 and t2.

explain gives a sequential scan and rearranges the query:

Can I create an index that will avoid that full scan?

Thanks in advance!

Advertisement

Answer

Although it should be the same plan, do either of these result in an improved plan?

Or:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement