BestHub
Sign in
Tag

Queries

1 views collected around this technical thread.

Top Architect
Top Architect
Jun 16, 2024 · Databases

20 Essential SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using prepared statements, proper data types, and transaction handling—to improve query performance and overall database efficiency.

Database OptimizationIndexesPerformance Tuning
0 likes · 11 min read
20 Essential SQL Optimization Techniques for Better Query Performance
FunTester
FunTester
Nov 25, 2022 · Databases

100 Common SQL Interview Questions with Answers and Explanations

This article presents 100 typical SQL interview questions covering basic queries, advanced techniques, and database design, illustrated with three sample tables (employee, department, job) and detailed answers, code examples, and analysis for both MySQL and Oracle implementations.

DatabaseInterviewQueries
0 likes · 50 min read
100 Common SQL Interview Questions with Answers and Explanations
Laravel Tech Community
Laravel Tech Community
Apr 30, 2020 · Databases

MySQL FAQ: Default Port, REGEXP, Index Limits, Common Queries, and Other Key Concepts

This article provides concise answers to common MySQL questions covering default ports, regular expression usage, index limits, query examples for retrieving rows, date functions, savepoints, ENUM types, storage engines, connection functions, ACLs, and other essential database concepts.

BackupDatabaseIndexes
0 likes · 9 min read
MySQL FAQ: Default Port, REGEXP, Index Limits, Common Queries, and Other Key Concepts
Qunar Tech Salon
Qunar Tech Salon
Mar 26, 2016 · Databases

MySQL User Management, Database and Table Operations Guide

This guide provides step‑by‑step instructions for connecting to MySQL, creating and managing users and permissions, displaying, creating and deleting databases and tables, performing backups and restores, and executing various query operations such as selecting, updating, and aggregating data.

BackupDatabase OperationsMySQL
0 likes · 14 min read
MySQL User Management, Database and Table Operations Guide