fetching the currenct financilal year data matching with previous year data by email,pan and mobile
I have more than 10lakh data in one table (example table name is :test1) and running below query and its taking more than 10 seconds to load the data so can you any one plz guide us to improve the load speed or any temp table can create and use it?
fetching the currenct financilal year data matching with previous year data by email,pan and mobile
I have more than 10lakh data in one table (example table name is :test1) and running below query and its taking more than 10 seconds to load the data so can you any one plz guide us to improve the load speed or any temp table can create and use it?