Infrastructure at your Service

Tag

index Archives - Blog dbi services

Morgan Patou

Documentum – Large documents in xPlore indexing

By | Application integration & Middleware, Entreprise content management | No Comments

Documentum is using xPlore for the Full Text indexing/search processes. If you aren’t very familiar with how xPlore is working, you might want to know how it is possible to index large documents or you might be confused about some documents not being indexed (and therefore not searchable). In this blog, I will try to explain how xPlore can be configured to be able to index these big documents without causing too much trouble because…

Read More
Grégory Steulet

Oracle Open World 2018 D1: Top Five MySQL Query Tuning Tips

By | Database Administration & Monitoring, Database management | No Comments

Yesterday (22.10.2018) I participated to the Janis Griffin’s session about “Top Five Query Tuning Tips” at #OOW2018. Janis is Senior DBA /Performance Evangelist for SolarWinds and Ace Director. She is specialized in Performance Tuning. She introduces her session by speaking about Challenges of Tuning. “Tuning takes time.”, “You cannot give enough power if SQL is ineficient”, “You therefore have to monitor wait time”. It sounds basic telling that it doesn’t worth adding CPU or memory when…

Read More
Oracle Team

Covering indexes in Oracle, and branch size

By | Oracle | No Comments

By Franck Pachot . A covering index is an index that contains all the columns required by your query, so that you don’t have to do a TABLE ACCESS BY INDEX ROWID, which is the major cost of an index range scan. You don’t need any special feature to do that in Oracle. Just add the required columns at the end of the index. In the execution plan you will see the columns used as…

Read More
Stephane Biehler

Documentum xPlore: Several ways to start an Index Agent

By | Application integration & Middleware | 6 Comments

In order to start index agents, you have several ways, depending on how you need to start them. 1. Use the documentum job dm_FTIndexAgentBoot. If you setup start_index_agents=T in the server.ini, the job will be called when the docbases are started. 2. Use the web interface: Login to http://server:9200/IndexAgent/ with docbase credentials and select “Start in normal mode” 3. Login to DA and go to Indexing Management -> Index Agents and Index Servers Right click…

Read More
Mouhamadou Diaw

PostgreSQL Index Suggestion With Powa

By | Database Administration & Monitoring | No Comments

A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present article I am going to show how this powerful tool can help by suggesting indexes which can optimize our queries. I am using postgeSQL 9.6 [[email protected] extension]# yum install postgresql96-server.x86_64 [[email protected] extension]# yum install postgresql96-contrib.x86_64 And Then I initialize a cluster [[email protected] extension]# /usr/pgsql-9.6/bin/postgresql96-setup…

Read More
Stephane Biehler

Documentum: IndexAgent uninstalled continues to queue requests

By | Application integration & Middleware | No Comments

We had a strange behavior by a customer regarding the indexing queue. We used to have two IA configured and we uninstalled one. I figured out that we still had indexing queue requests for the old index agent while it was totally uninstalled. I checked the following objects to see if the agent was still configured somewhere: dm_fulltext_index, dm_ftengine_config, dm_ftindex_agent_config. But the old IA was not declared anymore. The main problem is that it continued…

Read More
David Barbarin

Columnstore index rebuild cannot start

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was charged to migrate an SQL Server datawarehouse environment to a more recent version of SQL Server (from 2005 to 2012 in my case). After discussing with my customer we decided to benefit from the nonclustered columnstore index feature to improve reporting queries performance directly executed against the concerned database. So the implementation was successful and we included an additional job that consists in disabling as well as rebuilding…

Read More
David Barbarin

SQL Server 2016 : nonclustered columnstore index and aggregate pushdown

By | Development & Performance | 2 Comments

Did you miss aggregate pushdown capability shipped with columnstore index? Well, I remember the first time I heard about it is was when I read the very interesting blog post of Niko Neugebauer here with a very good covering of the topic (principle, advantages and limitations). So why to write a new blog post here? Well because since the last Niko’s blog article, this feature has been improved and I wanted to test it with…

Read More