SQL Server临时索引

-- 创建一个临时表
CREATE TABLE #TempTable (
    ID INT PRIMARY KEY,
    Name NVARCHAR(50)
);

-- 向临时表中插入数据
INSERT INTO #TempTable (ID, Name)
VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie');

-- 创建一个临时索引
CREATE INDEX IX_TempTable_Name ON #TempTable (Name);

SELECT
    i.name AS IndexName,
    t.name AS TableName,
    c.name AS ColumnName
FROM
    sys.indexes i
JOIN
    sys.tables t ON i.object_id = t.object_id
JOIN
    sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
JOIN
    sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE
    t.is_ms_shipped = 0 AND i.name LIKE 'IX_%' AND t.name LIKE '#%';

-- 删除临时索引
DROP INDEX IX_TempTable_Name ON #TempTable;