Question
4
Replies
2401
Views
FTB
Posted: August 9, 2018
Last activity: August 12, 2018
Closed
Columns Indexing in a Database table
Hi All,
Can we index all columns belong to a specific table? Is there any OOTB Pega functionality to index all columns belong to a specific table?
What would be the performance issue if we index all columns?
Thanks
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