我想看看表的哪些列应用了排序键(复合/交错)
我找到了这个文档,在这里我们可以分别过滤表和查看排序键。
SELECT column_name, data_type, distkey, sortkey
FROM svv_redshift_columns
WHERE schema_name = 'SCHEMA_NAME_HERE'
AND TABLE_NAME = 'TABLE_NAME_HERE'
AND isnull(sortkey, 0) != 0
ORDER BY sortkey