In DESIGNER Level
1)eliminate the unnecessory joins
2)use conditions as much as at the database level
3)edit the SQL query in the Query Panel as per requirment

In REPORTER level
...