Using temporary tables to optimise querying on large tables

[niranjankhare]

Hello,
I have a rather large table to select from, and the query needs to filter on multiple columns. There are suggestions online about using temporary tables and joining on them to speed up the queries.
I tried to look for how I can do this with diesel, but I couldn't get any examples.
Does diesel support this usecase? Could someone share / point to an example on how to do this if its possible?
Any help will be much appreciated!
Thanks,