In my model, I have many tables to be called multiple times in the simulation model. To reduce the total time the models need to run completely, I did a simple test. In the first test, I used the cell index (row numbers and column numbers) to look up the informations. In the second test, I searched the information using the names of the row headers and column headers to find all the informations I needed in the table. The difference in the amount of time between tests was huge, much more time was needed in the second test. Why does it happen? I would like to know the possible alternatives of searching information in tables that are faster to reduce the time of my simulation model.
