Ask Use The Index, Luke!
A Guide to Database Performance by Markus Winand
This community is
Retired:
Read-only mode for reference.
Questions Tagged With performance
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
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
3.1k
views
SELECT .... IN(....) WHERE ... LIKE %arbe% ....
May 27 '14 at 12:17
Markus Winand ♦♦
936
performance
postgresql
-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
1
answer
3.8k
views
In clauses and how index is used
Nov 11 '13 at 10:42
Markus Winand ♦♦
936
performance
index
select
mysql
1
vote
1
answer
3.5k
views
Oracle XMLType Experience
Oct 18 '13 at 17:05
Markus Winand ♦♦
936
oracle
performance
1
vote
1
answer
2.4k
views
Performance of conditional join
Sep 28 '12 at 16:24
Markus Winand ♦♦
936
performance
join