Use unsigned indexes in MySQL?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
3 views
Is there any win/loss of performance when using the UNSIGNED attribute in the primary keys?

Anyway, are there any good UNSIGNED indices, in addition to increasing the range of numbers?
by | 3 views

2 Answers

0 like 0 dislike
No.
by
0 like 0 dislike
So simply "No" without any arguments?
As I recall, unsigned int improves the performance indexes, and mysqlperformanceblog.com there was an article about this (can't find now exactly, but here www.mysqlperformanceblog.com/2008/12/22/high-performance-click-analysis-with-mysql/ for example here is on looking for unsigned). You can still read their book High Performance Mysql, preferably 2 part.
by

Related questions

0 like 0 dislike
5 answers
asked May 21, 2019 by XXX-prog
0 like 0 dislike
2 answers
0 like 0 dislike
7 answers
asked Mar 25, 2019 by Hint
0 like 0 dislike
6 answers
asked Mar 25, 2019 by opium
110,608 questions
257,186 answers
0 comments
28,009 users