The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
what is indexing, if indexing is crash what are database tables to recover in the jira
The index is a local cache of part of the database that JIRA uses for searching and reporting because database access is too slow.
I'm afraid the rest of your question does not make much sense. "if indexing is crash what are database tables to recover" - I don't know what that bit means.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events