creating indexes on the fly
323149Apr 21 2005 — edited Apr 22 2005From within a procedure can I create index on temporary table?
For a report, from within a procedure, I want to populate around 700 rows into a temporary table. Since inserting data is slower if the table already has an index, is it possible to create index from within the procedure and drop it when I am done with getting my results?
Does it make sense to create index on the fly or for just 700 rows it makes sense to have the index on the temporary table permanently?