I've installed OmniFind 1.2 on my new Power720 7+ with V7R1, SMP, the latest PTF-Level for the Database and OmniFind. With the attached program I've created a file 'employee' with 10,000 rows. I've tried serveral SQL statements and the performance difference is great.
select empid,skill from mylib.employee where contains(skill,'java' ) = 1 fetch first 10 rows only 31ms
with x as
(select a.empid,a.skill,row_number() over () as line from mylib.employee a where contains(skill,'java' ) = 1 ) 17066ms
select * from x fetch first 10 rows only
is there a solution for this poor performance?