Configuring limits are very useful when it comes to performance tuning. End-users might execute queries and the returning result set might contain hundred thousands of rows. Eventually, this will negatively impact the performance. We'll have to configure query limits to avoid such a situation.
Query limits can be configured at the user or the application role level. Applying query limits at the application role level will be easier. Open the Identity Manager and double-click on Application Role.
Click on the Permissions button. You'll see User/Application Role Permissions window. There are three tabs in this window. Click on the Query Limits tab.
All query limits are ignored by default. One of the limits is called as
Status Max Rows
and it's also ignored. TheMax Rows
attribute is set to100000
by default.Now let's assume that we need a limit that the result set cannot exceed 1000 rows for the
SalesManager
application role. Change theMax Rows
value to...