Definitions

from Wiktionary, Creative Commons Attribution/Share-Alike License.

  • adjective Not clustered

Etymologies

Sorry, no etymologies found.

Support

Help support Wordnik (and make this page ad-free) by adopting the word nonclustered.

Examples

  • The other indexes are called nonclustered indexes.

    SQL Server 2010

  • In SQL Server 2012, the ColumnStore index is always nonclustered.

    Site Home Conor Cunningham [MSFT] 2012

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

  • It is common practice to leave the fill factor for nonclustered indexes at the default setting.

    MSDN Blogs anuchaw 2010

  • When DBCC DBREINDEX rebuilds a nonclustered index, DBCC DBREINDEX puts on a shared table lock, which prevents all but SELECT operations from being performed on it.

    Site Home 2010

Comments

Log in or sign up to get involved in the conversation. It's quick and easy.