Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "index-match"

29 prompts matching "index-match"

"index-match" ✕ Clear all ✕
data Intermediate

ChatGPT Prompt: SQL Window Function Tutorial With Practical Examples

You are a SQL teacher. Walk me through window functions using realistic examples...

#data #sql #window-functions
👁 29 views
coding Advanced

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

#database design #schema #SQL
👁 18 views
data intermediate

Python Pandas Advanced GroupBy and Aggregation Techniques

Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...

#pandas #python #groupby
👁 16 views
coding Advanced

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database
👁 15 views
data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

#sql #optimization #performance
👁 15 views
coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

#postgresql #indexing #performance
👁 14 views
data advanced

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql
👁 14 views
coding Advanced

ChatGPT Prompt: Database Migration Plan with Rollback Strategy

Design a safe database migration plan for [SCHEMA CHANGE]. Details: - Database:...

#database migration #schema change #postgres
👁 14 views
data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#SQL optimization #query performance #database
👁 13 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
coding Intermediate

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

#coding #database #migration
👁 13 views
coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#sql migration prompt #rollback safe deployment #database schema change
👁 12 views
coding intermediate

JavaScript TypeScript Generic Utility Functions Library

Create a TypeScript utility functions library with these categories: 1) Array ut...

#TypeScript #utility functions #JavaScript
👁 12 views
coding Advanced

SQL Query Optimizer With EXPLAIN Plan Walk-Through

I have a slow SQL query against [DB ENGINE — Postgres / MySQL / SQL Server]. The...

#coding #sql #performance
👁 12 views
coding Advanced

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

#coding #sql #query optimization
👁 11 views
excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#excel #test-data #random
👁 11 views
coding Intermediate

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration
👁 11 views
data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization
👁 9 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 9 views
excel Intermediate

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#rolling #trend #dynamic-range
👁 6 views
coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database
👁 5 views
data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill
👁 4 views
finance Intermediate

Finance: Stop Me From Selling My Index Fund During a 20% Drawdown

The market is down [X%]. I have [POSITION]. I know intellectually I shouldn't se...

#finance #investing #behavioral-finance
👁 4 views
data Intermediate

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query
👁 4 views
coding Advanced

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database
👁 4 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval