Is it safe to clear the sys_tiny_url table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2022 12:48 PM
The sys_tiny_url table on our instance is very large.
We see there are some entries whose "Last Accessed" value is more than a year old.
Reading on the purpose of sys_tiny_url it seems like its something that can be generated or cached on demand.
Is it safe to clear the data in the sys_tiny_url table?
Thanks
- Labels:
-
Multiple Versions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2022 11:41 PM
Hi AfshinNia.
Yes, it is safe to clear the sys_tiny_url table. Basically, a record will be inserted into this table when the user builds a query in the list view which is too large to show in the URL.
for example, May have 1000 incident numbers with him and only want to view those in ListView. So he will build a query as shown in the image below
once he executes the filter as the query size is very high. the system will create a tiny URL record
and will show the URL as below
It will become very helpful when you need to execute the same query in the Background script for any other purpose. instead of adding all the incident numbers in the background script manually, we can make use of this tiny URL . so our code will be less complex
Just to be on the safe side. First, try clearing the records which are not been accessed for a long time. That probably means that the query was used only for the time thing.
Also additionally you can configure this table for AutoFlush using Table Cleanup to automatically purge the record based on the configuration so that you don't need to worry about it again.
Please mark it as helpful If my answer is helpful in any way,
Best regards,
Thameem