which is faster ?? 2 Selects for 1 For Select with 2 rows

[isaac_cm]

Hello,

I need expert advice about which is faster for a stored procedure in my database (about 200,000 records)

 

if I use 2 Select statements or use for select that return 2 rows ?

 

P.S: I created indexes for fields in the where clause.

 

Thanks

[amites]

try it both ways and include a print out of how long the query took to execute

 

run it a few dozen times each way and walah

[isaac_cm]

I mean in general does 2 select faster than 1 for select with 2 rows ?

[fenway]

I mean in general does 2 select faster than 1 for select with 2 rows ?

Depends on the query and the data... more info please?