When you are dealing with huge data, you need to limit your end user loading all the data from database without applying any parameter to the report.
Here we have an option to do it. There is parameter in IG that calls “apex$x” where x is the number of columns in your IG.
select EMPNO, ENAME,
JOB, MGR, HIREDATE,
SAL, COMM, DEPTNO
from EMP
where (1=2 or upper(“ENAME”) like :apex$1 or upper(“JOB”) like :apex$2)