Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having a Table with 40 columns and 28 Million Records. I am just doing a select * from that Table it takes 16 Minutes to load. Do we have any idea to further reduce this time?
Do you really need all columns and records from this table? If only the needed data are queried and transferred it might significantly reduce the run-times. Are after this the run-times yet too long you need to apply an incremental loading. Within the last two link-areas in this document: Advanced topics for creating a qlik datamodel you will find various examples how it could be done.
- Marcus
Hi Aswin !
Using select * is never a good practice, I suggest you, start by filtering into the LOAD only the required fields, and then use the WHERE clause to limit the number of records in the table to be read.
We need All columns and record as well.
you can ask the DBA to create index in the table, or if there is a possibility to parallelize the job in the database. Oracle I already did ..