SQL Code running faster on QLIKVIEW than SQL Manegement Studio
Hey everybody, I just recently started using Qlikview because my database went north from 1M rows. So, my query took 9 hours to complete using SQL management studio 2014 express for only 1.3M rows. When I put it on qliview I expanded it to all my products going shy of 4.5M. My Qlikview code is simply the connection to my server and then a SQL statement followed by my exact same code I use on SQL MS. Thing is, I thought it would take forever but it took only half an hour. I already checked some of the data and it seems to be working just right but something seems odd. Why would it be faster? does it make any sense? Can I trust my data? Thanks in advance!
Qlik doesn't execute any sql else it transfers it to the database and received just the results. Therefore it depends entirely to the performance of the db/driver/network how fast a query will be.
Beside this applying a filter to a query could increase the run-times more as just returning all data.
