Forward-only cursors are dynamic by default, which allows faster cursor opening and allows the result set to display updates made to the underlying tables. Dynamic cursors are faster and no longer require unique indexes.