Network profile

Chloe

Reputation

166

167
149
131

2018
2019
2020
2021

Top tag

mysql

Next privilege

200 Rep.

See reduced ads

Badges

1

8

Newest

Notable Question

Next badge

0/1

Impact

0 posts edited

0 helpful flags

11 votes cast

6 Questions

Votes Activity Newest Views

3

votes

2

answers

233

views

How did this statement update 3 rows in Postgres?

postgresql update random

Oct 10 '16 at 20:58 Community♦ 1

2

votes

3

answers

42

views

Is it possible to combine these three join queries into one?

join count

May 18 '18 at 17:07 Chloe 166

0

votes

1

answer

237

views

Why doesn't MySQL use indexes for subqueries?

mysql performance mysql-5.7

Jan 23 '20 at 21:17 Chloe 166

0

votes

1

answer

82

views

Is it faster to split a large table into 12 rolling monthly tables & use UNION them for reports or keep large table & delete rows older than 1 year?

mysql database-design union

Sep 24 '19 at 6:38 Akina 14.6k

1

0

votes

2

answers

65

views

How can I speed up this 2m5s query that has indices?

mysql mysql-5.6

Dec 13 '18 at 6:56 Akina 14.6k

1

0

votes

2

answers

3k

views

How can this unique index allow duplicate rows?

postgresql index

Aug 23 '16 at 20:11 Chloe 166

Database Administrators Stack Exchange works best with JavaScript enabled