Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to achieve clustered index and non-clustered index in sqlserver. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Create database myIndexDemo go use myIndexDemo go create table ABC (An int not null, B char (10), C varchar (10)) go insert into ABC select 1 create clustered index CLU_ABC on ABC (A) GO-View index sp_helpIndex ABC-insert data insert into ABC values (2) insert data insert into ABC values (2) 'C')-the physical structure of the entire table has changed because of the clustered index-the content of the query according to that index is: select * from ABC WITH (index = CLU_ABC) WHERE A > 1 AND A.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.