Re: PK Space calculation for table with composite key as PK
Posted by: Virinchi T
Date: September 27, 2023 02:51AM

Hi



I am trying to understand what is the correct way to calculate the Primary Key usage for a table in mysql 5.7

Imagine, I have table where primary is on two columns and each column have different datatype.
PRIMARY KEY ( 'column A','column B')


column A mediumint(5) unsigned
column B varchar(25)

In this case , what is correct way to calculate PK space usage for this table

Options: ReplyQuote


Subject
Written By
Posted
Re: PK Space calculation for table with composite key as PK
September 27, 2023 02:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.