I have Three environments, Test, Development and Production.
We are using the same production backup to refresh the Test, Dev database.
And trying to select from one table without order by clause,
Select * from table_a;
Test and Production are giving data with same order, but in Development its in different order. Only Primary key is there and no other index are there with this table. Everything looks similar for this table in all the environments.
Is there any specific reason that retrives data in different order.