关于索引的问题 [英] question about indexes

问题描述

我的数据库表student具有属性Studentid，名字，姓氏


我在列姓氏上创建索引

在学生(姓氏)上创建索引abc

My database table student have attributes Studentid,firstname,lastname


i create index on column lastname

Create index abc on student(lastname)



is above index is clustured or non clustered?

推荐答案

由于您尚未指定类型，因此将其视为非群集.

默认值为NONCLUSTERED.查看MSDN 文档 [

As you haven''t specified the type, this will be considered as Non Clustered.

The default is NONCLUSTERED. Look at MSDN documentation [^]here.

这篇关于关于索引的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！