Re: Which will give efficient performance? Use of Database view or Load & link in QVW
Totally agree with HIC. It takes lot of effort to optimize the DB. There are loads of external factors because there are other resources which are sharing the DB. And you can't optimize the DB unless you are owner/DBA and again it will have great impact on DB caching & execution plans. So I'd recommend you to play within QlikView. It's easy to test within QlikView. If your ODBC connection is taking long time then you need to lean on looking into the DB statistics.