Script to rebuild the ServiceNow table

Yuki21 · ‎05-16-2022

Hello.
How do I reconstruct the ServiceNow table in a script?

After executing the deletion script in the following job schedule
I want to add the process of rebuilding the table.

Is it possible to optimize table with ServiceNow script?

Hitoshi Ozawa · ‎05-17-2022

Yuki,

Check Mwatkins's reply in the following thread.

https://community.servicenow.com/community?id=community_question&sys_id=60b6c765db1cdbc01dcaf3231f96...

The thread is a little bit old but the following statement should still hold true.

Generally ServiceNow does not expose this layer of database administration because we don't want our customers to have to worry about it.

Not sure if the followings still hold but may be worth a try.

If you wanted to force reorganization on a certain table you could create a meaningless, hidden, custom field on that table. Then next time you want to reorganize the table you could remove said field.

Another way to force a table reorganization is to add an index to the table. Each time an index is added we do the same online alter operation that totally re-creates the table.

Following article by ServiceNow suggests using table cleaner. Check warning about performance before using it on production instance.

https://community.servicenow.com/community?id=community_article&sys_id=f6578d61db502810fb115583ca961...

Following Now Support page has instructions on how to use table cleaner.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0694151

View solution in original post

Tony Chatfield1 · ‎05-16-2022

Hi, your script deletes the content of your table - it does not delete the table.
Without details of the source data that will be populated back into the table or the process you will use to load\transform the data I do not think that the forum can provide an answer to your question.
Perhaps you could update this thread with clear and specific details of your requirement?

Yuki21 · ‎05-16-2022

申し訳ありませんが、スクリプトの抜粋を投稿しました。
「output_table_name」テーブルはカスタムテーブルです。
削除されるレコードは、「u_datetime」と呼ばれる日付形式の列によってフィルタリングされます。

Anil Lande · ‎05-16-2022

Hi,

As you have put log statements, are you getting those logs?

Please share which logs you are getting.

Thanks,

Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Yuki21 · ‎05-16-2022

I'm sorry, there is no log that can be presented immediately.
Is it difficult to answer without a log?

The point at issue is that fragmentation occurs when the above script deletes a record 
in the table, and ServiceNow's capacity is tight.
Therefore, we are considering the rebuilding process other than by requesting 
ServiceNow support.