If you have read anything I have posted up here, you know that I am not a big fan of Remote Views. In most cases, they don't scale. If they work for you however, great!! To address your immeidate problem, you could index the view cursor after the records have been fetched.... One tip, if you are using table buffering, be sure to switch to record buffering, build your indexes, then switch back to table buffering....
>I am upsizing an application to SQL. In a lot of my code, I use the seek command to move the record I want. When a table has been upsized to MS SQL, that table becomes a remote view in the DBC. Views have no indexes...what do I do? Do I simple issue an SQL select statment to get the one record I want?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only