cost of select query

[vishalg]

Hello,

I am using several select statements but one single table in a stored procedure. But this procedure will run over a million records. So that means the select statements will run over several million records. Can this hamper the speed of my engine?

PS. I am newbee.. as you can see its my first post here

Thank you.

[Hack]

Welcome to DevX

A very general answer to a very general question is it could possibly hamper the speed.

Given your needs, (and I don't know what they are), can you see other ways of doing what you are doing?