>Experience with what? With SEEK or with SELECT_SQL?
>Sorry, but your answer smells bad.
>
>>Looks like you have no experience with this Ed. When you do, then we'll talk.
>>
>>
>>>Well, some points are too obvious to be discussed even, but why do you put SEEK to 'prohibited' list? Do you want to look for one/few record(s) in 10 millions using SELECT-SQL? It's about the same as using rockets for sparrow hunting.

Ed

Given a SQL Server or Oracle backend, how else would you propose finding a single row out of millions... Even if designing a system using native tables, to ensure an upgrade path using a SEEK against base tables strikes me as a bad idea.

Mark