0
Proper indices. Withou an index it is a table scan. Head over to https://use-the-index-luke.com/ and read it.
Better hardware. If your hardware can pull in 20 gigabyte per second then yes, you can brute force that. Not THAT hard (epyc motherboard, number of u2 based SSD).