如何在Oracle中优化动态搜索查询

I am writing a stored procedure to perform a dynamic search that spans 10+ database tables. With millions of records in each table and a dynamic set of search parameters*, I am having some trouble optimizing the procedure. I am writing a stored procedure to perform a dy