Skip to Content
0
Former Member
Dec 13, 2013 at 08:00 AM

Index on concatenated object at universe level

23 Views

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