All Questions
0
votes
0
answers
4.0k
views

Index for PostgreSQL ORDER BY

Apr 21 '15 at 09:39 Lamplighter1
-1
votes
0
answers
5.1k
views

ORACLE 12C Unstructured Data Management (text mining)

Mar 11 '15 at 09:19 Helraezer0
1
vote
2
answers
8.6k
views

"Order by RAND()" - can use Index?

Feb 23 '15 at 12:06 Markus Winand ♦♦936
0
votes
2
answers
3.6k
views

index for better performance for a merge operation

Feb 20 '15 at 11:43 antilet1
0
votes
0
answers
3.4k
views

Join with inequalities only

Dec 16 '14 at 12:06 Markus Winand ♦♦936
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
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
3
votes
2
answers
2.7k
views

pagination with nulls

Oct 29 '14 at 22:39 Rocky46
0
votes
2
answers
2.8k
views

Is it possible for PKs to change after Export -> Import?

Oct 29 '14 at 09:21 KaiR6
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 Victor21
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
1
vote
1
answer
5.5k
views

Generate test data for a given case

Sep 14 '14 at 18:11 Markus Winand ♦♦936
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
1
vote
1
answer
1.9k
views

How to query for "previous page" with keyset pagination?

Aug 22 '14 at 04:21 alextsg16
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 Azimi1
2
votes
1
answer
2.8k
views

Table Names in Plural Form

Jul 31 '14 at 16:43 simas36
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
0
votes
0
answers
2.9k
views

Performance very bad in Postgresql 9.3

Jul 08 '14 at 11:54 Markus Winand ♦♦936
0
votes
1
answer
2.0k
views

Included columns and indexed views in SQL Server

Jun 30 '14 at 15:56 klaus triendl1
0
votes
1
answer
3.1k
views

SELECT .... IN(....) WHERE ... LIKE %arbe% ....

May 27 '14 at 12:17 Markus Winand ♦♦936
0
votes
1
answer
23.5k
views

partition exchange in Oracle

May 14 '14 at 22:14 Chris Saxon16
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
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 crackerplace6
0
votes
0
answers
40.9k
views

Fanout in R-Tree

Mar 27 '14 at 08:07 jamie1
0
votes
1
answer
2.6k
views

Think About It

Mar 26 '14 at 12:54 Markus Winand ♦♦936
0
votes
1
answer
2.9k
views

When INDEX SKIP SCAN is used

Mar 09 '14 at 14:30 Markus Winand ♦♦936
-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
1
vote
2
answers
5.1k
views

Useless index with function

Feb 23 '14 at 12:09 stef16
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
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