topic Will indexed tables help in accessing data in QlikView https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595874#M1111061 <HTML><HEAD></HEAD><BODY><P>We are pulling data from SAP (VBRK) table, we have indexed this table of <SPAN style="font-family: 'Calibri', 'sans-serif'; font-size: 11pt;">ERDAT&nbsp; field. We are pulling data on the condition of value of ERDAT field only. Will indexing on this field improve the execution speed or&nbsp; not. </SPAN></P></BODY></HTML> Tue, 04 Mar 2014 04:14:45 GMT rahulhv1 2014-03-04T04:14:45Z Will indexed tables help in accessing data https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595874#M1111061 <HTML><HEAD></HEAD><BODY><P>We are pulling data from SAP (VBRK) table, we have indexed this table of <SPAN style="font-family: 'Calibri', 'sans-serif'; font-size: 11pt;">ERDAT&nbsp; field. We are pulling data on the condition of value of ERDAT field only. Will indexing on this field improve the execution speed or&nbsp; not. </SPAN></P></BODY></HTML> Tue, 04 Mar 2014 04:14:45 GMT https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595874#M1111061 rahulhv1 2014-03-04T04:14:45Z Re: Will indexed tables help in accessing data https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595875#M1111062 <HTML><HEAD></HEAD><BODY><P>The where clause would work on an indexed field, the search would be faster, hence the execution speed is expected to be improved.</P></BODY></HTML> Tue, 04 Mar 2014 07:50:41 GMT https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595875#M1111062 tresB 2014-03-04T07:50:41Z Re: Will indexed tables help in accessing data https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595876#M1111063 <HTML><HEAD></HEAD><BODY><P>yes usually but it depends on several things; for a single table it depends mainly on the % of records you read with respect to the total. If you read all the records, using the index takes longer. For a very smalll table, index is useless.</P></BODY></HTML> Tue, 04 Mar 2014 22:35:53 GMT https://community.qlik.com/t5/QlikView/Will-indexed-tables-help-in-accessing-data/m-p/595876#M1111063 maxgro 2014-03-04T22:35:53Z