Secondary index -on the fly creation

Database
Enthusiast

Secondary index -on the fly creation

Hi,

As we know Secondary index creation will have to bear a subtable creation which some times be an extra burden.What if i create secondary index inside stored procedure before its usage and then drop it ? Would it be advisable to do this?? Any thoughts?

Thanks,

Mahesh.