HI,

Pega does not provide any OOTB functionality to index either a single column or all column of table.If any scenario comes to create index then Its application's DBA responsibility to create index for non pegacloud environment.

If it is pegacloud then you can raise a ticket to execute db scripts.

Why do you want to create index on all columns?Generally we create index to improve performance of any query.Index can be created on those columns which are present in where clause.

Thanks,

Abhinav

Please find the below link

https://community1.pega.com/community/product-support/question/how-create-index-table

HI,

Below link might help you.

https://community.pega.com/knowledgebase/articles/create-database-index-improve-performance-searches

Hi,

Pega does not provide the OOTB for indexing as Abhinav mentioned above. If Pega cloud and while creating the SR for indexing column table, share the corresponding java class for the table.