Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
compress_macro_ids_in_a_dataset_using_sql [2019/02/06 10:40] kcifreo |
compress_macro_ids_in_a_dataset_using_sql [2019/02/06 10:40] kcifreo |
||
---|---|---|---|
Line 3: | Line 3: | ||
This document describes the process (and SQLs) used to compress the IDs in a table (or many tables). For example, if you started with a table with 100 records that were scattered between ID=1001 and ID=5873, this routine could compress them so that the IDs ranged from 100 to 200. | This document describes the process (and SQLs) used to compress the IDs in a table (or many tables). For example, if you started with a table with 100 records that were scattered between ID=1001 and ID=5873, this routine could compress them so that the IDs ranged from 100 to 200. | ||
- | < | + | **WARNING: This article is for reference. The changes made will PERMANENTLY affect your data. This should only be carried out by a skilled implementer and SQL practitioner. Always Backup your data before running this routine.** |
===== Concept ===== | ===== Concept ===== | ||