SQL and generally the access to relationship database is
agnostic to the storage detail, and, in particular, to the ordering of data. The storage is optimized internally in the database system, you cannot affect it in any
direct way.
(Indirectly, one can change some
indexing options to optimize a database, but it has nothing to do with insert or delete operations (by the way, how did you imagine change in ordering upon delete? :-)); indexing is a totally different area. Indexing is used for optimization of performance at the expense of some data redundancy and does not effect semantics of database operation.
Please see:
http://en.wikipedia.org/wiki/Database_index[
^].)
You can only define the ordering of the query results by using SQL ORDER BY clause, please see:
http://www.sql-tutorial.com/sql-order-by-sql-tutorial/[
^],
http://www.w3schools.com/sql/sql_orderby.asp[
^],
http://msdn.microsoft.com/en-us/library/ms188385%28v=sql.110%29.aspx[
^].
—SA