We have run the SQL Index Optimizer and have placed all sql processing into a single SQL stored procedure.


- This SP use SQL CURSORS ?

- This SP use only SQL Tables ?

- This SP do a lot of INSERT/UPDATE ?

With simple SELECT query SQL~=VFP,
but with big tables and complex query SQL is faster.

However, for me,
this comparison is without metric because we are confronting two different things completely.