SET ROLE and SYSROLEAUTH
This is a discussion on SET ROLE and SYSROLEAUTH within the Informix forums, part of the Database Server Software category; --> Greetings, I have noticed that each execution of the SET ROLE command consistently takes 3 seconds to execute. It ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:03 AM
| ||||
| ||||
 SET ROLE and SYSROLEAUTH Greetings, I have noticed that each execution of the SET ROLE command consistently takes 3 seconds to execute. It appears that this process causes 2 x sequential scans of SYSROLEAUTH on our system; this table has > 60K records .... hence the long elapsed time. Can anyone shed some light on this for me ? What exactly does the SET ROLE command do under the covers ? And why should it scan SYSROLEAUTH ? Regards, John      |
|
04-20-2008, 11:06 AM
| ||||
| ||||
| Re: SET ROLE and SYSROLEAUTH Hi We are using IDS 7.3.1. Our DBA has alerted Tech Support (no response yet) Yes - SYSROLEAUTH appears to be uniquely indexed on rolename and grantee. Ordinary selects executed against this table with rolename and grantee do not sequentially scan. Hmmmmm ... John |
Linear Mode
