best index method for heavy update and read table

Posted in 2014

PUSHPA KUMARA — Sun, 09 Nov 2014 05:58:29 — source: IIUG Forums & Mailing Lists

Hello, any one have a experience about best index method for table which has heavy updates and read continues and long time. currently table has column by column index for several column but users facing slowness every time so what would be the best way to avoid this issue. Thanks Pushpa

↪ replying to PUSHPA KUMARA

PUSHPA — Sun, 09 Nov 2014 06:01:07 — source: IIUG Forums & Mailing Lists

Hello, forgot to say the informix version is 11.70 Thanks pushpa

↪ replying to PUSHPA

Art Kagel — Sun, 09 Nov 2014 12:17:11 — source: IIUG Forums & Mailing Lists

What is slow? Updates? Inserts? Deletes? Queries? All? Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Nov 9, 2014 at 1:01 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hello, > > forgot to say the informix version is 11.70 > > Thanks > pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3f5bc4a7ff805076c06e1

↪ replying to Art Kagel

PUSHPA — Mon, 10 Nov 2014 03:38:37 — source: IIUG Forums & Mailing Lists

Hello Art, Thanks for the repply, update insert and select is slow. Thanks Pushpa

↪ replying to PUSHPA

Art Kagel — Mon, 10 Nov 2014 03:51:53 — source: IIUG Forums & Mailing Lists

Run typical query, update, and inserts with set explain on and let's see the sqexplain output. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Nov 9, 2014 at 10:38 PM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hello Art, > > Thanks for the repply, > > update insert and select is slow. > > Thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b34398efab57405077914a5