Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Intermedia
Hi Ludwig,
select pat_part1, pat_part2 from dr$quick_text$p
order by length(pat_part2) desc;
Thomas
Ludwig Maier wrote:
> hi folks!
>
> i've got the problem to maintain a oracle-text index wich is about 20gig
> big. what kind of packages or tool should i use to reorganize this index and
> how can i look how many waste there's in my index?
> the main problem is the performance when searching documents with wildcard
> on the lefht side (like "*test*"), do you have any suggsestions on this?
> thanks in advance
Received on Tue Jul 15 2003 - 15:21:15 CDT