How to use a custom Select statement to a View for Group Activities

What would be the best option to use a custom Select statement to a View for Group Activities.  I've taken the generated a View from the elgg list river generated select statement and I can retrieve the information quicker and want to use the view instead of the Elgg generated select statement