Re: [sqr-users] Thinking about trying something - looking forideas

["George Jansen" <GJANSEN@aflcio.org>]

Dynamic SQL will not per se prevent the use of indexes. If you were to
be performing essentially the same query hundreds or thousands of times,
you'd want to avoid dynamic SQL. In this case, you'll be running one
query per table, won't you? So the additional overhead in the parsing is
likely to be vanishingly small compared to the other and unavoidable
costs of the query.

Do make sure that your schema is reasonably well analyzed, though.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users