Revisamos de forma cada artículos de nuestro sitio web con la meta de enseñarte siempre información más veraz y actualizada.
Ejemplo: ¿cuáles son todos los diferentes tipos de índices en sql?
"There are two types of Indexes in SQL Server
1. Clustered Index
A clustered index defines the order in which data
is physically stored in a table. Table data can
be sorted in only way, therefore, there can be only
one clustered index per table. In SQL Server,
the primary key constraint automatically creates a
clustered index on that particular column.
2. Non-Clustered Index
A non-clustered index doesn’t sort the physical
data inside the table. In fact, a non-clustered
index is stored at one place and table data is
stored in another place. This is similar to a
textbook where the book content is located in o
ne place and the index is located in another.
This allows for more than one non-clustered index per table."Recuerda algo, que tienes la capacidad de explicar .
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)