problem with generation of sql code

[epris]

hi to everybody,

i start to use powerdesigner for creating an er model and database for a project at university.

so you can see sql code generate from powerdesigner

http://www.eprisblog.it/xxx.sql

it generates sql code from a phisical data model file (

http://www.eprisblog.it/studio_medico.pdm

)

It shows that warnings message when it produces sql code:
1)An index should not include another index. on PRESTAZIONE_PK
2) An index should not include another index. on ABILITATO_PK

I found on help manual: Delete the index that includes an existing index

can you help me for resolve that problem?

 

[epris]

please sorry there is a problem with pdm data file so i can't to upload on web space... so i hope you can help me without it

 

[brokenbone]

Hi!

You have 3 columns in your primary key (PRESTAZIONE). Then you have indexes on 3 columns on the same table, two of which are already in primary key collection. You don't need indexes on these columns since PK already creates an index.

Hope I'm right and this helps you.

BB