MSSQL DB View Optimisation

Job ID: 32195770

Budget: ₹12,000 – ₹15,000 INR

Hi
We have a product for contract Labor Management System in which we capture In and Out Punching data. We have one Database View for generating reports. Currently for retrieving one record time required is between 50 to 60 Seconds. We want to optimize that specific VIEW to reduce the best possible time