Jeremy Jongsma <[EMAIL PROTECTED]> writes:
> My questions are:
> 1) How can #3 take 30 times as long as #2, given that in my databse they
> have the exact same number of rows returned and are drawn from the exact
> same tables?
> 2) How is it possible for #3, a subset of #1 with a very simple WH
I have a view, vw_tc_user_acccess, for determing user access to certain
objects. On my machine, I get the following query execution times:
1. SELECT * FROM vw_tc_user_access: 33.04ms
2. SELECT * FROM vw_tc_user_access WHERE object_type = 'FORUM': 3.49ms
3. SELECT * FROM vw_tc_user_access WHERE o
