basic index range scan cost = index blevel + ceil(index selectivity x leaf blocks) + ceil(table selectivity x clustering factor)
In order to have a lower cost for index scans, usually is good to change/lower the clustering factor for an index
exemple :
Niciun comentariu:
Trimiteți un comentariu