> What are the ramifications of renaming the table (containing 8000> rows) and creating a view of the same name?
View does not admit ORDER BY clause, at least, Standard does not.
Sergey