I am in a situation where oracle view is not visible to me however I can fire a select query and get the data.
As it is not visible in BI tool, I have to create a derived table like
derived table: VW_TEST
query : select * from vw_test
I know some of disadvantages of derived tables. One of them is performance issue. If underlying SQL is causing performance issue then its pretty obvious that my derived table gives me the same behavior. Now, I am using just a SELECT * statement.