Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Viewers,
I heard somewhere that creating indexes may increase the performance of the QVD.
what exactly Index does and how to create?
Plz help me out in this with perfect example.
Thanks in adv!!!
Index is available in Database not in Qlikview.
A database index supports fast data access in a very similar way to a book index or a printed phone book
Thanks for suggestion
So then how we can creating indexes for the QVD performance???
Could you elaborate little bit more.
am still confusing on this that where it can be used and relation between index and QVD???
Plz could some one help me out in this.
Thanks in adv!!!
In QlikView you cannot create, update or delete any type of indexes. This is a fact and no suggestion. QlikView will perform at top speed because it handles "indexes" completely automated under the hood.
In effect all fields and all values - both text and numbers are indexed and deduplicated through its symbol table generation. That is why QlikView is so extremely fast in most situations...
The full context of what you heard is likely that creating indexes on your SQL tables will improve the performance of loading data into Qlikview. Qlikview is very efficient but a database without indexes is very inefficient.
Without indexes on tables you would perform constant full table scans.
I am not sure how that would affect performance in Qlikview if you were doing something simple like Load * from table1 but if you put any type of where clause on it the performance would suffer terribly.
It's poor design not to have a primary key or clustered index on a SQL table and those tables without clustered indexes are called heaps. Without indexes there is no way for you to search directly for John Smith, it must go down every single row looking for John Smith.
Hopefully you have a DBA who ensures the database servers are properly configured and maintained.