>
> 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?
Casting?
> Executionsplan as part StoredProcedure:
> ExecutionPlan NOT as part SP:
The execution plans don't show up in the archives. Judging by the rest from your post, you are using some HTML email format. Try repostng in plain text without attachments.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
