Home » Server Options » Text & interMedia » Does Text indexes impacts on DML activities performance (Database 11g)
Does Text indexes impacts on DML activities performance [message #586195] Tue, 04 June 2013 06:33 Go to next message
ganesh_jadhav0509
Messages: 74
Registered: May 2007
Location: Chester
Member
Hi,

I have some text indexes on a table.

Now my question is, Does text indexes Impacts performance of insert, update or delete activities?

Regards

Ganesh Jadhav

Report message to a moderator

Re: Does Text indexes impacts on DML activities performance [message #586197 is a reply to message #586195] Tue, 04 June 2013 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't think so.

Regards
Michel

Report message to a moderator

Re: Does Text indexes impacts on DML activities performance [message #586254 is a reply to message #586197] Tue, 04 June 2013 21:22 Go to previous message
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
Senior Member
I believe there would be some negligible impact, but nothing significant. Any insert, update, or delete would affect the domain index tables. The extent of the impact would depend on whether your index parameters include transactional or sync(on commit) or if such things are delayed and processed later.

Report message to a moderator

Previous Topic: read from text file
Next Topic: MultiByte Characters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 00:30:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.