Report question

Question: What techniques are most effective for dealing with millions of records?