Index on concatenated object at universe level

[Former Member]

Hi

i have an object called object with version(ex:- object1 ||'v'|| object2) which is created at universe level !!

if we add that object to query filters it's taking lot of time (~ 10 minutes )to retrieve 20 rows

suggest me how to handle this. i am thinking that, need to apply index awareness at universe level. Otherwise i need to create this object at DB table level and need to create the index on this object at DB level.

My guess is universe level index is good

Thanks,

Bhaskar

[Former Member]

Making something index aware at the universe level is just adding a helper to try and get the query to make best use of the database's existing indexing. the universe has no concept of its own indexing - you cannot, for example, include indexes on a derived table in the way that you would to a table that you create at the database level.

If you're on Oracle then from 8i you would be able to create a function-based index on a concatenation. Use your favourite search engine to look up the details on how to do that.

[Former Member]

Hi Bhaskar,

Index at DB level will be a better option.

In universe you just make the object index aware, you don't create indexes in universe.

If there are no indexes in database and you are setting indexaware in an universe object, it will have no benefits.

I would suggest to set the indexes at DB end.

Thanks

Gaurav