infinite-dataset-hub/SQLQuerySpeedTracker

1---2license: mit3tags:4- infinite-dataset-hub5- synthetic6---7 8# SQLQuerySpeedTracker9 10tags: query analysis, optimization, performance11 12_Note: This is an AI-generated dataset so its content may be inaccurate or false_13 14**Dataset Description:**15 16The '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.17 18**CSV Content Preview:**19 20```21id,query,execution_time_before_optimization,execution_time_after_optimization,query_complexity,rows_affected,optimized_by,label221,"SELECT * FROM customers WHERE last_order_date < '2020-01-01'",2.5,"0.8",Low,10000,"User A","Improved"232,"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"243,"UPDATE accounts SET status = 'inactive' WHERE last_login < DATE_SUB(NOW(), INTERVAL 1 YEAR)",1.9,"0.9",High,500,"User C","Improved"254,"SELECT * FROM product_reviews WHERE rating >= 4",3.2,"1.5",Medium,5000,"User D","Improved"265,"DELETE FROM transactions WHERE transaction_date < '2021-01-01' AND status = 'completed'",4.0,"1.0",High,15000,"User E","Improved"27```28 29**Source of the data:**30 31The dataset was generated using the [Infinite Dataset Hub](https://huggingface.co/spaces/infinite-dataset-hub/infinite-dataset-hub) and microsoft/Phi-3-mini-4k-instruct using the query 'sql optimization':32 33- **Dataset Generation Page**: https://huggingface.co/spaces/infinite-dataset-hub/infinite-dataset-hub?q=sql+optimization&dataset=SQLQuerySpeedTracker&tags=query+analysis,+optimization,+performance34- **Model**: https://huggingface.co/microsoft/Phi-3-mini-4k-instruct35- **More Datasets**: https://huggingface.co/datasets?other=infinite-dataset-hub36