Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mazarinen
Contributor II
Contributor II

Indexing DW

Hello,

 

Does qlik use the indexes created in the DW at all e.g. when creating a qvd-file?

 

My question is, are indexes in a DW unnecessary if the only "user" of the DW is QLIK or do qlik benefit from indexes aswell?

 

/M 

Labels (2)
3 Replies
maheshkuttappa
Creator II
Creator II

Indexing helps in speeding up data extraction from DW.  We use SQL queries to get only the required data into QVD this will depend on the performance of DW. Having indexing will help speed up this process.  

 

Mazarinen
Contributor II
Contributor II
Author

Thanks, that was what I was wondering!

maheshkuttappa
Creator II
Creator II

Please mark the answer as correct if satisfied. This would help others with similar questions.