Skip to Content (Press Enter)
2026-03-23 09-58-51
Pedro Domingues
Champion
3Views
4Comments
Primary Key Indexes
Question
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
0
0
25 Feb 2011
Copy Link
UserImage.jpg
Pedro Magalhães
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!
0
0
25 Feb 2011
Copy Link
2026-03-23 09-58-51
Pedro Domingues
Champion
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
0
0
25 Feb 2011
Copy Link
UserImage.jpg
Pedro Magalhães
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
0
0
25 Feb 2011
Copy Link
2026-03-23 09-58-51
Pedro Domingues
Champion
Hi Pedro,

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

Thanks a lot.

Cheers,
Pedro Domingues
0
0
25 Feb 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.