Thanks for sharing. I will look into it. Say for example, If I have 5 GB of data, it will apply 'Table Scan' , right ? Does qlikview support Indexes ( clustered, Non Clustered equivalent kind of indexes) ?
Qlikview is not a relational database management system. Forget everything about queries, indexes, tables scans, cursors and all those other artifacts of rdbms systems that are part of the technical implementation of such systems. Qlikview doesn't have them.
Well, there is something you could call an indexing system. But not the way you think of them with your sql goggles on. Just read the pdf I linked to. Or this blog post: Symbol Tables and Bit-Stuffed Pointers