Fetch records efficiently
-
My Table has millions of records and my query is fetching 500 million records for 1 day to the SSRS report. so, It is taking too long time to fetch the data. Could anybody can suggest me how to narrow down or improve my query. Thanks in Advance, Avinash.
-
My Table has millions of records and my query is fetching 500 million records for 1 day to the SSRS report. so, It is taking too long time to fetch the data. Could anybody can suggest me how to narrow down or improve my query. Thanks in Advance, Avinash.
Without seeing the query, how can anyone suggest how to narrow it down?
The difficult we do right away... ...the impossible takes slightly longer.
-
My Table has millions of records and my query is fetching 500 million records for 1 day to the SSRS report. so, It is taking too long time to fetch the data. Could anybody can suggest me how to narrow down or improve my query. Thanks in Advance, Avinash.