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
MYSQL indexing. Parvilno how to make indexes?
asked May 21, 2019 by XXX-prog
0 like 0 dislike
2 answers
How to create indexes MySQL in Laravel?
asked Apr 9, 2019 by nimfai
0 like 0 dislike
7 answers
Question on indexes in MySQL?
asked Mar 25, 2019 by Hint
0 like 0 dislike
6 answers
Used in update query of mysql indexes?
asked Mar 25, 2019 by opium

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
28,009 users