Primary Key Indexes

Primary Key Indexes

  
Hi there,

Recently i've noticed that none of my tables have an index related to the PK of each table.

In the Service Studio the only Indexes created automatically are the ones that are related to the FK.

My question is:

These indexes are automatically created but we cannot see them in the Service Studio?

Cheers,
Pedro Domingues
Hello, Pedro

By default, Primary Keys in SQL Server automatically create an index for its field.
I found someone with a simmilar question here.

Hope this helps!
Hi Pedro,

Thanks for your answer. I forgot to say that i'm using ORACLE.

My point is:
If the primary are automatically created why can't we see it in Service Studio?

This point can lead to users creating indexes for PK in the Service Studio.

Cheers,
Pedro Domingues
Hello again,

I checked and ORACLE has the same behaviour as SQL Server on the PRIMARY KEY - INDEX issue.

As for the Service Center issue, I guess you're right. It should be explicit in Service Center that the primary keys already have an Index.
Maybe "Wisdom of Crowds" would be a good option to point out your wish for a future version.

Regards,
Pedro Magalhães
Hi Pedro,

I will add the idea in the "Wisdom of the crowds"

Thanks a lot.

Cheers,
Pedro Domingues