Home » RDBMS Server » Performance Tuning » Using Consumer groups
Using Consumer groups [message #109121] Tue, 22 February 2005 04:35
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi all,

I have set up a SQL-Plan for using consumer groups.
My szenario is :
1st Plan : ERP Users 90 % Overall Performance
2nd Plan : Named Users 10 % Overall Performance

within 2nd Plan :
read users 90 %
r/w users 10 %

We do need to grant also the r/w access with this performance.
Will it be better to place the consumer groups to the profiles instead of the users ?
I will attach my script for building the plan
Any hints and helps welcome

Previous Topic: Re: materialized view
Next Topic: Replace Outer Join with Unions
Goto Forum:
  


Current Time: Tue Feb 27 20:01:57 CST 2024