If you disable a non-clustered index, are the statistics still used?

Channel:
Peter Schneider
Subscribers:
4,140
Published on ● Video Link: https://www.youtube.com/watch?v=gSCo8gLygfA


Duration: 2:45
1 views
0

If you disable a non-clustered index, are the statistics still used?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/173206/chad-baldwin)Chad Baldwin |
(dba.stackexchange.com/users/88609/zikato)Zikato |
A special thanks goes out to the (https://dba.stackexchange.com/questions/322790/if-you-disable-a-non-clustered-index-are-the-statistics-still-used)Stackexchange community |

I wish you all a wonderful day! Stay safe :)

sql-server-2017 sql-server index



Other Videos By Peter Schneider


2023-02-03Event functionality in C
2023-02-03passing bytes32 to constructor
2023-02-03I don't understand what's wrong with this code
2023-02-03Abundant number implementation
2023-02-03Aiken code- any actual (recent) use?
2023-02-03How to measure current up to 1000A and not go bankrupt
2023-02-03VRFCoordinatorV2Mock's fulfillRandomWords not being called in hardhat local deployment
2023-02-03Passing function as argument, with capture, what type to declare in function?
2023-02-03is Max() not counted as a aggregation function?
2023-02-03What is the correct way to check and delete temp table?
2023-02-03If you disable a non-clustered index, are the statistics still used?
2023-02-03Is it possible to know how long an ESP8266 was in deep sleep?
2023-02-03Form builder not getting checkbox values
2023-02-03NTC resistor to balance ambient temperature change on precision current controlled lamp
2023-02-03What is pull up and pull down on a pin?
2023-02-03indexing multiple columns in a table in MySQL
2023-02-03How much power can a 6 nm transistor handle?
2023-02-03HomePod 1st + 2nd gen
2023-02-03Why is my iPhone crashing and reporting higher battery percentage?
2023-02-02Is it safe to use ERC 998 now?
2023-02-02What’s the meaning of this square with a down arrow icon on my HomePod in Control Center?


Tags:
sql-server-2017
sql-server
index