Hi Bruce,

Other than examining the Indexes for Rushmore, SQL does not automatically sort records based on the current index setting. Like Ed said, you will want to Set Order To 0 before initiating your SQL.

SQL also ignores filters. i.e., SQL does not automatically add the expression Filter() to the where clause of your SQL.


>I believe this is true, but I'd like to verify it. Is the following statement always correct?:
>
>An SQL Select always ignores any indexes or filters currently on a table.