Oracle: recommendations to improve the performance of the SELECT command

I need to get recommendations to improve the performance of any SELECT command without using Enterprise Manager.

For example, for the command & # 39; SELECT COUNT (*) FROM sh.sales & # 39 ;, the result should be:
CREATE MATERIALIZED VIEW REGISTER,
CREATE MATERIALIZED VIEW,
STATISTICS OF THE MEETING TABLE