DEFINITIONS

Definitions More Info.
Definition ID993
TitlePOSTGRESQL
CategoryNOTES
Definitionmaintenance clustered index
Definition Descriptionhttps://superuser.com/questions/811117/how-do-i-know-if-my-postgres-table-is-clustered

Clustred Index Sorgusu:

SELECT relname AS table_name
FROM pg_class c
JOIN pg_index i ON i.indrelid = c.oid
WHERE relkind = 'r' AND relhasindex AND i.indisclustered

RecordBycunay
Record Date05-12-2019 13:47:40
Düzenle
Kopyala
Sil