Is there any issues if we create NONCLUSTERED INDEXES in side a Stored procedure?
Is there any issues if we create NONCLUSTERED INDEXES in side a Stored procedure?
@hi kev Riley,
thanks for your replay.
my stored procedure having multiple while loops it is taking more time to execute .so i have created indexes and drop that indexes after the query execution.
the while loops are mandatory to get report correctly shall i use this.
18 People are following this question.