Hi,
I have a table ORDER with no index , partition , keys defined and I am executing below sql query to retrive the CODE starts with some value for first 200 mn records . It is taking too long to run .Is there any way I can rewrite this query.
SELECT * FROM ORDER WHERE ROWNUM <= 200000000 AND ((CODE LIKE '1234423678%' ));