Subscriber Count

    459

Subscribe to Posts by Email

Pages

Rows in Sort order without order by clause?

I have been asked by one of colleague (Vasu) about a weird issue, that the query returns rows in sort order in one database not in the other database.

Without having much hassle, by running dbms_xplan.display_cursor(‘sql_id’,NULL,’ADVANCED) mode tell’s us the optimizer parameter “_gby_hash_aggregation_enabled” is having different values in each database. Which is mean to perform […]