Performance Improvement while extracting data from SQL Server

[nihhalmca]

Hi All,

There are two tables 1. Dimension - Product 2. Fact - TableX, it has 10 years data.

Requirement - want to extract only Yesterday data. This query take much time, how can i improve performance here (QlikView side).

And please let me know how can i improve performance at SQL side as well if possible?

Thanks,

Nihhal.

[anderseriksson]

Crucial for performance is having an index on the Date field in the SQL Server table.