Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tidb新增索引对表大小有限制吗
|
username: 小于同学
How long does it take to add an index to 18 million records?
|
username: 小于同学
|
username: The image you uploaded cannot be processed for translation. Please provide the text content directly for translation.
|
username: It depends on the version. After version 6, the speed of adding indexes has increased significantly.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: Which version? If it’s 6.5 or above, it will be very fast.
|
username: TiDB supports online DDL, adding indexes does not affect the business.
|
username: It depends on the version. Higher versions do not have explicit limitations.
|
username: A single-field index takes about 2 minutes, but the time may vary depending on the performance of each server.
|
username: 
|
username: 
|
username: 
|
username: Tested on TIDB 6.5.3, the speed is very fast, around 2 to 3 minutes.
|
username: 
|
username: The new version is very fast, estimated to take three to four minutes.
|
username: 
|
username: Based on the machine’s performance, I estimate a few minutes.