Hi Guys, Here, some basic tips about How to write optimized Stored Procedure. Its always better to use table owner in query like SELECT col1,col2….coln FROM dbo.Tablename Due to this, SQL que…