183
Views
6
Comments
Solved
How to index a table using extension (integration studio)
Question

Hi Experts,


How can i create an Index from extension DB, as per checking it is disabled.


2023-02-10 19-42-59
João Melo
 
MVP
Solution

Hi Joshua, why would you need to create an index through an extension? Can you elaborate on your use case?

UserImage.jpg
Jay-jay

Hi joao, 

Thank you for your reply.

As you can see there is no indexing, i want to crate an index via outsystem.

And also we do not have access on the DB.

Is there a way to create an index?




2012-03-16 12-21-09
João Rosado
Staff

Hi,


Entities imported via Integration Studio are outside the control of the platform. If you need indexes on those entities they need ti be created directly on the external database they are coming from.


Regards,

João Rosado


2020-02-28 09-46-54
Eduardo Jauch

Hi Joshua, 

If this entity is from an external database, I don't think you can create an index from OutSystems (not sure though). 

If you need an index or a constraint, you will have to ask to who controls the database, probably. 

Cheers 

João was faster... ??

UserImage.jpg
Jay-jay

Hi,


Will do on the DB side and thank you for your input.


Thanks and Best Regards.

2023-02-10 19-42-59
João Melo
 
MVP

Yup, that's true, if it is an external database, you'll do all the changes you need externally, connecting directly to the database. You cannot change the database from within Outsystems tools.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.