Optimizing Stored Procedures for GitHub Copilot

Prompt 1: Basic SQL Stored Procedure Optimization

Use Case: To help developers optimize simple SQL stored procedures using GitHub Copilot.

Prompt: You have a SQL stored procedure that needs optimization. The procedure details are as follows:

database_type: {database_type}
procedure_purpose: {procedure_purpose}
performance_issue: {performance_issue}


First identify the performance issues in the stored procedure, including:
- Long-running queries  
- Inefficient joins
- Missing indexes

and give a query to identify the performance issues.

Then, generate a basic optimized version of the stored procedure focusing on:
Generate a basic optimized version of the stored procedure focusing on:
- Index usage
- Query structure
- Simple performance improvements
- Standard SQL patterns