search

Home  >  Q&A  >  body text

java - 数据库删除数据导致id不连续,有什么影响么

数据库删除数据导致id不连续,有什么影响么?性能或者其他方面的影响。。

大家讲道理大家讲道理2949 days ago412

reply all(4)I'll reply

  • 迷茫

    迷茫2017-04-18 10:12:21

    No problem, you can modify your table structure to make it continuous

    reply
    0
  • 黄舟

    黄舟2017-04-18 10:12:21

    No impact, just add indexes to frequently queried fields

    reply
    0
  • 伊谢尔伦

    伊谢尔伦2017-04-18 10:12:21

    ID is just a unique identifier, it doesn’t matter. . And try not to use ID as the primary business key during the development process

    reply
    0
  • 迷茫

    迷茫2017-04-18 10:12:21

    It has no impact. In some designs, the ID is a string generated using UUID(), which is not continuous in the first place

    reply
    0
  • Cancelreply