| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> interMedia Text 8.1.6 question
Greetings, fellow DBAs.
We got a rather big conText index on some big table with assorted types of documents in BLOBs (text, ms word, rtf, html, etc.) filtered with INSO. Over time the table grew and querying over it using contains() became very slow. Explain plan for a simple query with single contains() over the table analyzed with estimate statistics sample 10 percent gave 533 for domain index scan and added up to 866 for slightly over 1000 rows retrieval from some 120k total rows. Query executed for almost 1 minute. I think it's time to reorganize the table and underlying DR$ tables and indexes, but I am not sure if doing so with ALTER TABLE MOVE/REBUILD INDEX won't invalidate the domain index. Reindexing the table anew would take eons to complete and the db is production. Question is: is it safe to reorganize DR$ tables using above technique? ctxsrv will be brought down for the time of reogranization of course. Also, while we're at it - any suggestions on storage clauses of these tables? Are default values assigned by conText appropriate for tables having over 100000 documents indexed with new ones being added constantly at a rate of 200-300 per day? Also, will we benefit from moving these tables and indexes into LMTs?
Any suggestions and definite dos/donts are very appreciated.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer.Received on Thu Nov 29 2001 - 15:04:49 CST
![]() |
![]() |