COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: Subz on 10 Feb 2020 03:30:36 AM

Title: Datasource: Command Block for using/ activate Index?
Post by: Subz on 10 Feb 2020 03:30:36 AM
Hello  :)

due to performance reasons we are trying to force the Datasource (Oracle) to use a special index by executing a SQL. One idea is to use command blocks in the datasource before executing the sql. Does someone know if this is possible and maybe got a XML example for us?

Thx  :)