Hello. I explain my task
1st database is 19c
Imagine
table1 name is “test1 (id number pk,title varchar2(100), title1 varchar2(100)” -this table have million of rows, the user search like this
select * from test1
where title like ‘%hya’ ; (maybe this option> like ‘hya%’ ; like ‘%hya%’)
table2 name is “text1 (id number pk, text clob)" -this table have million of rows, the user search like this
select * from table2
where clob like ‘%avatar’ ; (maybe this option> like ‘avatar%’ ; like ‘%avatar%’)
Above situatuon which index (or indexes create two type of index ) will help me for realy fast ?
I think that maybe >this table use in memory or db_cache_use or etc
Please give me options for indexes or dba solutions