How Do You Optimize A Stored Procedure?

1.	How Do You Optimize A Stored Procedure?
Answer» By creating APPROPRIATE INDEXES on TABLES. Writing a query BASED on the index and how to pick up the appropriate index. By creating appropriate indexes on tables. Writing a query based on the index and how to pick up the appropriate index.

Answer»

By creating APPROPRIATE INDEXES on TABLES. Writing a query BASED on the index and how to pick up the appropriate index.

By creating appropriate indexes on tables. Writing a query based on the index and how to pick up the appropriate index.

Discussion