Tag: database-internals


Found 73 results for 'database-internals'.


1) mysql - No 'Copying to tmp table' state in profiling a mysql query
2) sql-server - Why does nested loops join only support left joins?
3) sql-server - Unclear update conflict
4) mysql - Storage space requirements for a varchar(40) column to store 'abcd' with charset 'ucs2' and 'utf8mb4'?
5) postgresql - What is the overhead for varchar(n)?
6) postgresql - Is the mapping between PostgreSQL system tables and information_schema views documented?
7) sql-server - SQL Server chooses unselective index
8) postgresql - Why is intarray's push `+` so much faster than array-to-element concatenation `||`?
9) postgresql - Why does a JSON element return text when it's not text?
10) sql-server - Index Seek Operator Cost
11) postgresql - PostgreSQL 9.6 column dropping and side-effects on SQL functions with CTEs
12) sql-server - Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?
13) sql-server - NEWID() In Joined Virtual Table Causes Unintended Cross Apply Behavior
14) mysql - Does partitioning help with lookups and inserts/updates by primary key?
15) sql-server - Set statistics I/O for nested loops
16) sql-server-2016 - Measuring plan eviction
17) mysql - Why does MySQL allow HAVING to use SELECT aliases?
18) performance - Difference between avg Disk sec/write and io_stall_write_ms
19) sql-server - Is there a way to see how SQL Server 2012 defines new identities?
20) postgresql - What determines if a bytea has 1 or 4 extra bytes?
21) sql-server - DELETE vs TRUNCATE
22) join - How is a join performed by a database engine?
23) sql-server - Why is this stream aggregate necessary?
24) sql-server - Index Pages (page type 2)
25) configuration - What triggers the SSRS to generate a log file or modify a current one?
26) sql-server - TempDB uses a lot of space in buffer pool
27) sql-server - Cardinality estimate outside the histogram
28) sql-server - List ROW_OVERFLOW_DATA pages for a specific table
29) sql-server - SQL Server 2014 compression and maximum row size
30) sql-server - Nonclustered index storage on clustered columnstore
31) sql-server - Diff backup fails with error 3035 but log backup succeeds
32) postgresql - varchar(n) size?
33) sql-server - Why does the optimizer choose nested loops over merge joins here?
34) query-performance - Badly-formed histogram causes bad estimates on Nested Loop
35) sql-server - How does SQL Server reuse reserved pages after deleting a table
36) sql-server - Size of individual transactions in log file
37) postgresql - What are system columns used for in PostgreSQL?
38) postgresql - Confused about maximum connections in PostgreSQL
39) sql-server - Identical tables, identical columns, identical records, but why different record sizes?
40) sql-server - High PAGELATCH_* and WRITELOG waits. Are they related?
41) sql-server - Union implemented with Hash Match operator
42) sql-server - How does SQL Server handle the data for a query where there is not enough room in the buffer cache?
43) postgresql - varchar(n) size?
44) oracle - Specificness of Tablespace
45) oracle - Where can I find the algorithm used in Oracle Range Partitioning
46) postgresql - When does a table get an oid?
47) postgresql - SPI postgresql - insert data into table from postgres.c
48) sql-server - Logical reads different when accessing the same LOB data
49) postgresql - Why does a JSON element return text when it's not text?
50) sql-server - Get minimal logging when loading data into temporary tables