What are all the ways of doing optimization in qlikview? Can someone please explain me on this?
That all is a matter of experience and strongly depends on your data.
You can find many information at Community, just utilize search.
Have a look at Steve's blog that he has just written for Quick Intelligence.
The following papers are also helpful :
Retrieving data ...