Best ChatGPT prompts for Database Administrators

Given a SQL query that is currently taking 10 seconds to execute, with a WHERE clause filtering on a non-indexed column, and a JOIN operation with a large table, provide a step-by-step plan to optimize the query, including recommendations for indexing, rewriting the JOIN operation, and potentially leveraging query caching or materialized views. Assume the database is running on a Snowflake instance with 16 warehouses and the query is executed 1000 times per hour.

Develop a Python script using the Pandas library to clean and preprocess a dataset containing customer information, including handling missing values, data normalization, and feature scaling. The dataset has 100,000 rows and 20 columns, with a mix of numeric, categorical, and text data. Provide a detailed explanation of the steps involved and the reasoning behind each decision, including any assumptions made about the data distribution and potential outliers.

Design an ETL pipeline to extract data from a relational database, transform it into a denormalized format, and load it into a data warehouse for analysis. The pipeline should handle 10,000 rows per hour, with data coming from 5 different tables, and should include error handling, logging, and data validation. Provide a detailed architecture diagram and a step-by-step implementation plan, including any necessary SQL scripts, Python code, or other tooling.

Using statistical techniques such as regression analysis and hypothesis testing, analyze the performance of a set of SQL queries executed on a database over a period of time, with metrics including execution time, CPU usage, and memory allocation. Develop a model to predict query performance based on factors such as query complexity, data volume, and system load, and provide recommendations for optimizing query performance and reducing resource utilization. Assume the data is stored in a Tableau dashboard and provide a step-by-step plan for data extraction, modeling, and visualization.