Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

4
Replies
2997
Views
 Surya Teja Mokka (MokkaSurya) FTB
FTB
US
MokkaSurya Member since 2012 3 posts
FTB
Posted: August 9, 2018
Last activity: August 12, 2018
Posted: 9 Aug 2018 16:42 EDT
Last activity: 12 Aug 2018 14:26 EDT
Closed

Columns Indexing in a Database table

Report

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

Data Integration
Posted: 4 years ago
Posted: 10 Aug 2018 3:22 EDT
Abhinav Gupta (Abhinav7) PEGA Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN
Report

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

suman boorla
Posted: 4 years ago
Posted: 12 Aug 2018 14:26 EDT
Chandrasekhar Gollamudi VN (chandrasekhar_g) PEGA Senior Manager, Technical Support - Runtime Engine and Search
Pegasystems Inc.
IN
Report

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.

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice