> If you modify last_user_event_2 to select user and event info in the view, 
> and just put there where clause directly on the view which is not joined to 
> anything, instead of on the "extra copy" of the users table like you were 
> showing previously, I would expect that the performance should be excellent.

But I need user_id and user_group to be outside of the view definition.
user_id and user_group are dynamic values, as in, I need to call this
query multiple times for different user_ids and user_groups .

Reply via email to