Ask Use The Index, Luke!
A Guide to Database Performance by Markus Winand
This community is
Retired:
Read-only mode for reference.
All Questions
0
votes
0
answers
4.0k
views
Index for PostgreSQL ORDER BY
Apr 21 '15 at 09:39
Lamplighter
1
postgresql
-1
votes
0
answers
5.1k
views
ORACLE 12C Unstructured Data Management (text mining)
Mar 11 '15 at 09:19
Helraezer
0
oracle
unstructured
12c
data
1
vote
2
answers
8.6k
views
"Order by RAND()" - can use Index?
Feb 23 '15 at 12:06
Markus Winand ♦♦
936
random
index
mysql
order-by-rand
0
votes
2
answers
3.6k
views
index for better performance for a merge operation
Feb 20 '15 at 11:43
antilet
1
merge
index
0
votes
0
answers
3.4k
views
Join with inequalities only
Dec 16 '14 at 12:06
Markus Winand ♦♦
936
inequality
join
0
votes
1
answer
2.5k
views
PostgreSQL Scripts: Performance Testing and Scalability problem and question
Nov 12 '14 at 14:53
Markus Winand ♦♦
936
testing
postgresql
scalability
0
votes
1
answer
4.6k
views
PostgreSQL Bitmap Heap Scan on index is very slow but Index Only Scan is fast
Oct 31 '14 at 11:31
Markus Winand ♦♦
936
index
postgresql
postgres
sql
3
votes
2
answers
2.7k
views
pagination with nulls
Oct 29 '14 at 22:39
Rocky
46
pagination
0
votes
2
answers
2.8k
views
Is it possible for PKs to change after Export -> Import?
Oct 29 '14 at 09:21
KaiR
6
integrity
mysql
2
votes
1
answer
4.8k
views
How can I influence the Postgres planner to always do a bitmap index scan+bitmap heap scan instead of an index scan ?
Sep 25 '14 at 22:26
Victor
21
performance
postgresql
0
votes
2
answers
6.1k
views
different execution plans after failing over from primary to standby server
Sep 17 '14 at 11:46
Markus Winand ♦♦
936
oracle
index
update
1
vote
1
answer
5.5k
views
Generate test data for a given case
Sep 14 '14 at 18:11
Markus Winand ♦♦
936
testcase
postgres
0
votes
1
answer
9.0k
views
Database design suggestions for a data scraping/warehouse application?
Aug 27 '14 at 09:29
Markus Winand ♦♦
936
mysql
optimization
database
1
vote
1
answer
1.9k
views
How to query for "previous page" with keyset pagination?
Aug 22 '14 at 04:21
alextsg
16
pagination
postgresql
0
votes
0
answers
6.2k
views
Why we can't use a compound index with two or more independent range conditions?
Aug 10 '14 at 07:22
Majid Azimi
1
database
sql
2
votes
1
answer
2.8k
views
Table Names in Plural Form
Jul 31 '14 at 16:43
simas
36
table
0
votes
1
answer
4.8k
views
We want to buy the book but I can't
Jul 18 '14 at 21:36
Markus Winand ♦♦
936
book
0
votes
0
answers
2.9k
views
Performance very bad in Postgresql 9.3
Jul 08 '14 at 11:54
Markus Winand ♦♦
936
performance
issue
0
votes
1
answer
2.0k
views
Included columns and indexed views in SQL Server
Jun 30 '14 at 15:56
klaus triendl
1
sqlserver
features
0
votes
1
answer
3.1k
views
SELECT .... IN(....) WHERE ... LIKE %arbe% ....
May 27 '14 at 12:17
Markus Winand ♦♦
936
performance
postgresql
0
votes
1
answer
23.5k
views
partition exchange in Oracle
May 14 '14 at 22:14
Chris Saxon
16
partition_exchange
1
vote
2
answers
36.0k
views
SQL vs NoSQL: what about other issues than ACID and scalibility?
Apr 30 '14 at 22:27
Markus Winand ♦♦
936
copied
0
votes
1
answer
2.9k
views
Is leafnode to leafnode traversal required for index lookup by the database ?
Apr 09 '14 at 21:20
crackerplace
6
btree
indexing
0
votes
0
answers
40.9k
views
Fanout in R-Tree
Mar 27 '14 at 08:07
jamie
1
tree
indexing
0
votes
1
answer
2.6k
views
Think About It
Mar 26 '14 at 12:54
Markus Winand ♦♦
936
reflection
0
votes
1
answer
2.9k
views
When INDEX SKIP SCAN is used
Mar 09 '14 at 14:30
Markus Winand ♦♦
936
access
index
path
scan
skip
-2
votes
0
answers
3.9k
views
range scan for (ID1,ID2)-eqjoin and range filter for T is slow with PK(ID1,ID2,T) and fast with IDX(ID1,ID2) - reality or fear?
Mar 07 '14 at 10:06
Markus Winand ♦♦
936
performance
index
1
vote
2
answers
5.1k
views
Useless index with function
Feb 23 '14 at 12:09
stef
16
optimizer
indexing
4
votes
1
answer
34.3k
views
Why is this postgres query doing a bitmap heap scan after the index scan?
Feb 16 '14 at 08:15
Markus Winand ♦♦
936
postgres
1
vote
1
answer
23.9k
views
Should I always create a clustered index on a primary key?
Jan 28 '14 at 12:33
Markus Winand ♦♦
936
clustered
index
primary
key