Index in partition table?

[Ashok kumar]

Hi,

I have created the table with list partition. See the below table structure.

drop table if exists test;
create table test
(

id int ,
name varchar(20)
)
partition by list(id)
(
partition p1 values in(1,2,3,4,5),
partition p2 values in(6,7,8,9,10)
);

We have partition the table based in the field "id".

Will it create the implicit index for the field "id" while creating the table? Or Is need to create the index explicitly?

Thanks.

Regards,
S.Ashokkumar
India.