for indexing issue

[Ravindar Reddy]

what is indexing, if indexing is crash what are database tables to recover in the jira

[Thomas Schlegel]

Hi Ravindar,

the index is a kind of cache for your Jira. It is not stored in your database, but on the filesystem of your Jira server. It is used for faster search of your issues, full text search and so on.

Here is a FAQ about indexing in Jira: 

https://confluence.atlassian.com/jirakb/jira-indexing-faq-776654790.html

[Ravindar Reddy]

Thank you .. Thomas

[Thomas Schlegel]

you're welcome :)

[Nic Brough [Adaptavist]]

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.