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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think so.

Regards
Michel
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: 9077
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.
Previous Topic: read from text file
Next Topic: MultiByte Characters
Goto Forum:
  


Current Time: Thu Mar 28 08:49:43 CDT 2024