store proceder is T-SQL commend , in store proceders 
baunch of commends and bunch of statement excuted at a time 
know as store proceder.
  ex :
       select (avg)sal,ename from emp
       
       we dont write evry time this commend 
           
       simply write of this commend insted of
        
      write this commend (STORE PROCEDER)
      
      CREATE PROC USD_AVGSAL FROM EMP
      U EXECUTE N NUMER OF TIMES WITH THIS AND 
      EXEC USD_AVGSAL...........
Index  is  read from spcific recored or data know as index.
and index use of retrive data fast.faster excution.
 syntax:
        create non clusterd index cid_eid_emp
         
          on emp(eid)
         on primary.