internal order of oracle tables
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Thu, 30 Jun 94 13:50:00 -0500
Message-ID: <12a.2993.905_at_compudata.com>
Date: Thu, 30 Jun 94 13:50:00 -0500
Message-ID: <12a.2993.905_at_compudata.com>
-> is there anyway to have oracle keep a table in order by
-> primary keys? just wondering if we can get away from having
-> to use order by on some of our selects.
NO!
The cost of moving thing around when records are changed far outway any possible select savings.
What's wrong with indexing in your app? Received on Thu Jun 30 1994 - 20:50:00 CEST