infinite-dataset-hub/SQLQuerySpeedTracker

SQLQuerySpeedTracker

tags: query analysis, optimization, performance

Note: This is an AI-generated dataset so its content may be inaccurate or false

Dataset Description:

The 'SQLQuerySpeedTracker' dataset is designed to assist Machine Learning practitioners in understanding and predicting the performance of SQL queries after optimization efforts. It includes a variety of SQL query performance metrics and features that may contribute to the speed and efficiency of query execution.

CSV Content Preview:

id,query,execution_time_before_optimization,execution_time_after_optimization,query_complexity,rows_affected,optimized_by,label
1,"SELECT * FROM customers WHERE last_order_date < '2020-01-01'",2.5,"0.8",Low,10000,"User A","Improved"
2,"SELECT column1, column2 FROM orders JOIN customers ON orders.customer_id = customers.id WHERE amount > 1000",5.3,"2.1",Medium,2000,"User B","Improved"
3,"UPDATE accounts SET status = 'inactive' WHERE last_login < DATE_SUB(NOW(), INTERVAL 1 YEAR)",1.9,"0.9",High,500,"User C","Improved"
4,"SELECT * FROM product_reviews WHERE rating >= 4",3.2,"1.5",Medium,5000,"User D","Improved"
5,"DELETE FROM transactions WHERE transaction_date < '2021-01-01' AND status = 'completed'",4.0,"1.0",High,15000,"User E","Improved"

Source of the data:

The dataset was generated using the Infinite Dataset Hub and microsoft/Phi-3-mini-4k-instruct using the query 'sql optimization':

• —Dataset Generation Page: https://huggingface.co/spaces/infinite-dataset-hub/infinite-dataset-hub?q=sql+optimization&dataset=SQLQuerySpeedTracker&tags=query+analysis,+optimization,+performance
• —Model: https://huggingface.co/microsoft/Phi-3-mini-4k-instruct
• —More Datasets: https://huggingface.co/datasets?other=infinite-dataset-hub