This takes care of normalizing the data in embedded repeating structures like page lists / page groups to a new table.
2) Full text search index
This takes care of providing full text search functionality with the product. Since searching the contents in the BLOB is not possible through the use of database queries, full text search comes in very handy. This is done using Apache Lucene libraries till 7.1.6 and using Elastic Search library from 7.1.7 and beyond.
Kindly explain what you mean by
>> Due to data volume; It takes too much time to do reindexing inside pega so can we do it at database end.
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread
We have also sent you a private message opening up a communication channel in case you have any further questions.