On Azure sql server ,I have created CLUSTERED INDEX partition for a table with 7 millions record . Then my website takes more than 10 seconds to load data .But if I don't create CLUSTERED INDEX partition , my website takes nearly 6 seconds to load data. If I use the same database which created CLUSTERED INDEX partition on sql server enterprise and put it on a server located in the LAN, my website takes about 3 seconds to load data .
What I have tried:
Could you tell me any solution for this problem. Thanks