Pre-Loading Oracle Text indexes into Memory

http://www.oracle.com/technology/products/text/htd... By jayachitra On 2nd Sep 08 Pre-Loading Oracle Text indexes into Memory     1votes Oracle Text indexes are stored in Oracle Database relational tables. These tables normallyreside on disk. Systems with large memory configurations generally benefit greatly fromOracle caching - a second or subsequent search for a particular term is generally much faster than the first search.

Comments (0)    Who like this? (1)

Please Login / Register to submit your Comments.

No comments. Start your discussion.

Related Stories

1 votes'Can't Give Up Now' 1 votesSQL Server out of memory: Troubleshoot and avoid SQL memory problems 1 votesThe JavaScript Source: Text Effects : Vertical Marquee 1 votesAndrew Fryer's Blog : Using Full Text Searching SQL Server 2008 1 votesOn Indexes and Views - SQL Server Central

Popular Stories

Advertisements