SQL OPTIMIZATION

See more:

SQL

I have simple sql query with 8 tables of which 3 tables have 30, 60 and 80 lakhs of records
I have applied inner joins on tables to which 35 lakhs of records of displayed but to display these records its takes hell lot of time.
I have applied index on the date column used in where clause and have also applied index on primary keys of the tables having lakhs of records.
for date column in where clause instead of between I have used "greater than equal to (>)" and "less than equal to (<)" operator.
Apart from above steps what other steps can I apply to improve the performance of the query.