-
I have a table with 100,000 rows. I have a col status_cd with possible values of ( 'I' OR 'P'). I want to get min transaction_id of column with value P.
My question is , is it better to have a either
1. Cursor c1 is select * from table where status_cd = 'P'
order by transaction_id desc ;
open cursor and get first row and exit from cursor
2. select min(transcation_id) from table where status_cd = 'P' ;
Which one runs faster and why if i have index on status_cd.
Thanks in advance
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|