Purging an EIM table
Submitted by dtadmin on Tue, 01/10/2012 - 18:16
When purging data from the EIM table, use the TRUNCATE command as opposed to DELETE. The TRUNCATE command will release the data blocks and reset the high water mark while DELETE will not, thus causing additional blocks to be read during processing. Also, be sure to drop and re-create the indexes on the EIM table to release the empty blocks.
Related Articles:
Browse Categories
User login
Navigation
Popular content
- Autosys Job Handling (13,609)
- GE UNIVERSAL REMOTE INSTRUCTIONS (12,357)
- Siebel User properties (9,094)
- Test 1 - NC Drivers License Test - DMV Question Dump (8,770)
- Making a View "Read Only" based on a criteria: Aspect User Property (4,216)
- Siebel Application Response Measurement (SARM) (4,144)
- Siebel Predefined Queries (PDQ) – Reference (4,080)
- Siebel Server Component Event Logging (3,662)
- Strategies for Building Team Cohesion (3,153)
- How to create the EBC’s in Siebel (3,085)
Readers who viewed this page, also viewed:
- Siebel Standard interactivity configuration tips (62.5%)
- Will EIM interfere or affect Visual Basic code built into the application? (50.0%)
- Does EIM support case values (50.0%)
- Web Portal Integration with Siebel Applications (50.0%)
- XML Tools And Utilities (50.0%)
- Siebel XML Web Interface (50.0%)
- How To Add a New Property or Set the Value of an Existing Property in the Siebel Message XML that is Being Sent Out Through a Workflow Process (37.5%)
- Siebel Webservice And EAI - Basic Concepts ans Steps Involved (37.5%)
- Philips SRU2103/27 Universal Remote control codes for TV, VCR, Set-top Box (37.5%)
- Real time Siebel EIM (Enterprise Integration Manager) Interview Questions – Part 2 (37.5%)
