#Temporary views and functions return errors stating they're not allowed.
Use Text-only results, and include the execution plan to see the index has been used.
Q&A for spacecraft operators, scientists, engineers, and enthusiasts
-- #Temporary tables and indexes work
-- Procedures can be created, but I don't know the current syntax.
-- Use Results to Text.
CREATE TABLE #Test (id int IDENTITY(1,1) NOT NULL, v VARCHAR(MAX) NOT NULL)
CREATE INDEX #IX_T on #Test(id)
INSERT INTO #Test(v) SELECT @@VERSION
INSERT INTO #Test(v) VALUES ('Yay!')
SELECT * FROM #Test Order By id