Select * from SPECIAL-VIEW
Where bigint_ID = @SPECIAL_ID
Order by datefield desc
When I call this statement it works ok and fast (< 1sek).
If I took this statement in a storedprocedure it takes much longer (>10Sek).
Any hint why it is handle in an other way in a storedprocedure?
Executionsplan as part StoredProcedure:
ExecutionPlan NOT as part SP:
In fact same statement, but working different way .. :-(
Mfg
Gerd
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
