I have a table with below structure :
Test1(c_num number ,c_first_name varchar2(50), c_last_name varchar2(50))
1)There is a
normal index on
2)The table has nearly
5 million records.
I have a procedure as you can see below. I want to display the
Count(*) along with other columns.I want to know if there are better ways of doing this so that we can have better performance.
create or replace procedure get_members(o_result out sys_refcursor) is begin open o_result for select c_num, c_first_name, c_last_name, (select count(*) from test1) members_cnt -->Is there a better way instead of doing this? from test1; end;
Thanks in advance