I have tuned a query using FIRST_ROWS hint and tested in Enterprise edition. The Database is going to degrade from Enterprise edition to standard edition soon. So the query (with FIRST_ROWS) should work in Standard edition also. I don't have standard edition available to test. I googled about this, but couldn't find any information. Does the FIRST_ROWS hint works in Oracle Standard Edition?