every query taking lot of time on table large. testing purpose want queries implemented first few rows of table. ex : in select * table rownum=1,there check rows i.e if rownum 1 or not. want test queries few rows save time.
if want select top n rown must use -
select * table rownum <= n;
Comments
Post a Comment