In SQL 2000 operatia "sort" nu era exclusa din "query plan", vezi http://sqlblog.com/blogs/tibor_karaszi/archive/2007/11/28/sorted-views.aspx.

Kimberly Tripp semnaleaza un "workaround" de folosit cu atentie:

http://sqlskills.com/blogs/Kimberly/post/SQL-2000-v-2005-Using-Top-100-Percent-in-a-View.aspx