Define "intensive". I/O intense, CPU intense, Latch Intense, etc.

Simple, measure the metric that you say is "intense" and tune the query. If your query is using lots of CPU, figure out how to reduce it. If it's causing a lot of I/O, reduce it.