In a table 1 million records and there in no clustered index. A select query is taking long time and whenever checking fragmentation level it is showing fragmentation level is 60%. what could the region and how to resolve it.
Kindly share your valuable views here.
Thanks in advance.