Re: Indexing View Columns?
Date: Thu, 10 Mar 2011 07:33:54 -0800 (PST)
thanks for your reply. Nah, sorry, it's not that easy. I'm trying to find an alternative group management method on database level that is able to manage both explicit group assignment and implicit assignment via an sql statement.
For instance (simplified tables here):
VIEW IMPLICIT_ASSIGN -- simplified code...
SELECT ident_id, 512 FROM employeeData WHERE -- several conditions UNION ALL
SELECT ident_id, 13012 FROM someOtherTable WHERE -- several conditions UNION ALL
SELECT ident_id, 4099 FROM thirdTable WHERE -- several conditions
with the purpose of handling those groups seamlessly:
SELECT * FROM EXPLICIT_ASSIGN
UNION ALL SELECT * FROM IMPLICIT_ASSIGN So one only needs to know the group number to get its members. The purpose of not using higher level scripting is that I a) can use this technique on the database level within triggers and stuff and
b) feed it SUBQUERIES like SELECT * FROM all_groups WHERE group_id IN (...)
Thanks, NewUser2k8 Received on Thu Mar 10 2011 - 09:33:54 CST