Ask Use The Index, Luke!
A Guide to Database Performance by Markus Winand
English
The Book
Ask
Consulting
All Questions
active
newest
hottest
most voted
0
votes
1
answer
1.2k
views
For a Simple Select, At what point do indexes considerably speed up the query?
May 10 at 08:58
dsfsfe
(suspended)
query-speed
0
votes
1
answer
1.4k
views
query regd the CBO decision
May 10 at 08:57
dsfsfe
(suspended)
index-choice
optimizer
0
votes
1
answer
248
views
Index search using the concatenated index and SECOND column in WHERE clause.
Apr 15 at 13:45
Markus Winand ♦♦
321
postgres
1
vote
1
answer
284
views
A set of questions on the book..
Apr 15 at 11:24
Dmitry
26
postgres
sql
0
votes
2
answers
1.2k
views
Indexing during INSERT vs after INSERT
Mar 25 at 19:25
Lukas
1
insert
innodb
index
pk
0
votes
1
answer
405
views
query is not using indexes when i was tried creating the indexes on columns
Feb 23 at 17:25
sql_sniffer
1
index
sql
query-speed
mysql
1
vote
1
answer
473
views
DELETE Problem
Feb 08 at 12:34
dx05
16
oracle
delete
1
vote
1
answer
878
views
Traversal of B-Tree data structures
Oct 08 '12 at 22:26
Hiawatha
21
index
btree
0
votes
1
answer
1.0k
views
Why do bind parameters affect performance?
Sep 28 '12 at 22:27
Hiawatha
21
optimizer
sql
1
vote
1
answer
489
views
Performance of conditional join
Sep 28 '12 at 16:24
Markus Winand ♦♦
321
performance
join
1
vote
2
answers
963
views
Does MySQL manage big IN() statements well ?
Jul 18 '12 at 15:08
vaceletm
16
index
join
where
mysql
0
votes
1
answer
3.3k
views
Updating multiple rows using a subquery in SQL
Jun 30 '12 at 11:43
Camille
(suspended)
subquery
update
sql
0
votes
3
answers
3.0k
views
Examples for Function Based Indexes?
Mar 25 '12 at 15:52
Castorp
1
function-based
1
vote
1
answer
1.4k
views
Should 'id' (the primary key) be included in an index
Jan 03 '12 at 15:24
Jan
26
index
include
0
votes
1
answer
982
views
Best index for a multiple join-tables and filter
Jan 03 '12 at 14:31
Markus Winand ♦♦
321
index
join
where
0
votes
2
answers
1.1k
views
How to find out how to speed-up nested query?
Dec 09 '11 at 15:01
Jan
26
index
mapreduce
sql
0
votes
2
answers
1.0k
views
QUERYING SAME TABLE IN ALL DATABASES
Nov 14 '11 at 02:23
seyfigo
1
table
querying
same
1
vote
2
answers
2.3k
views
"Order by RAND()" - can use Index?
Oct 31 '11 at 11:57
Imagin
(suspended)
random
index
mysql
order-by-rand
0
votes
3
answers
1.3k
views
Range select with two columns
Oct 14 '11 at 08:34
Markus Winand ♦♦
321
index
range
select
1
vote
1
answer
879
views
Multi-table select OR join?
Oct 11 '11 at 14:58
Markus Winand ♦♦
321
join
select
mysql
1
vote
1
answer
2.1k
views
SQL Memory
Jul 05 '11 at 11:44
Markus Winand ♦♦
321
execution
complex
plans
1
vote
1
answer
1.6k
views
FIltering by Count in MySQL
Jul 05 '11 at 10:26
Markus Winand ♦♦
321
count
mysql
0
votes
2
answers
3.0k
views
Having Date of Birth, how to use an index for a lookup by age?
Mar 03 '11 at 01:12
Markus Winand ♦♦
321
age
1
vote
2
answers
2.3k
views
The Birthday Problem
Feb 18 '11 at 00:58
Markus Winand ♦♦
321
where-clause
exercise
1
vote
1
answer
1.7k
views
Correct ordering in a tree based structure
Feb 17 '11 at 02:25
Markus Winand ♦♦
321
ordering
tree
0
votes
1
answer
2.0k
views
What is Ask.Use-The-Index-Luke.com?
Aug 20 '10 at 02:58
Markus Winand ♦♦
321
meta
Browse
Questions
Unanswered questions
Tags
Badges
Users
Ask
Ask Your Question
Account
Login / Create account
Recent Activity
tags
postgres
delete
oracle
pk
innodb
insert
btree
performance
optimizer
index-choice
include
where
mapreduce
sql
update
subquery
range
select
join
same
querying
table
query-speed
count
tree
posts per page
15
30
50