On 3/12/2015 5:03 AM, Pratik Thaker wrote:
> I am using Oracle 11g2 and we are having a schema where few tables are having
> more than 100 million rows (some of them are Varchar2 100 bytes). And we have
> to frequently do the LIKE based search on those tables. Sometimes we need to
> join the tab
Hi,
I am using Oracle 11g2 and we are having a schema where few tables are having
more than 100 million rows (some of them are Varchar2 100 bytes). And we have
to frequently do the LIKE based search on those tables. Sometimes we need to
join the tables also. Insert / Updates are also happening