Sql Server Index Analysis
LangChain Hub prompt: henriqueholtz/sql-server-index-analysis
SQL SERVER: Help me understand about indexes in a given table. Here are the table details:
- Table Name: {TABLE_NAME}
- Table rows (quantity): {TABLE_ROWS_QUANTITY}
{TABLE_DETAILS_AND_EXISTING_INDEXES}
And the script based on the statistics (sys.dm_db_missing_index_groups, sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_details) is suggesting me to create a new index:
{CREATE_INDEX_STATEMENT}
IMPORTANT: Think carefully about the table structure, its PK, current indexes and so, and then explain me why I should create the new index or consider another option (like recreating the current index), or ignore the suggestion
How to Use
Use with LangChain: hub.pull("henriqueholtz/sql-server-index-analysis")
Related Prompts
More prompts in Data & Analytics
Sql Agent System Prompt
LangChain Hub prompt: langchain-ai/sql-agent-system-prompt
Buyer Persona Legend
Generate detailed User Personas for your Business with data neatly organized into a table.
Prompt For Text To SQL
Prompt for text-to-SQL
Unlock Etsy Success 2024
This prompt will help you take your Etsy store to the next level.
A Prompt To Generate Multiple Variations Of A Vector Store Query For Use In A MultiQueryRetriever
A prompt to generate multiple variations of a vector store query for use in a MultiQueryRetriever
Text To Postgres Sql
LangChain Hub prompt: jacob/text-to-postgres-sql