Book a Demo

Author Topic: creating indexes  (Read 3634 times)

katrin

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
creating indexes
« on: July 08, 2008, 04:43:31 pm »
Has anyone ever tried to modify DDL transformation templates so that there would be indexes on foreign key columns? Does anyone know how to do it?

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: creating indexes
« Reply #1 on: July 09, 2008, 12:22:37 am »
You're not going to like this, but...

Unlike the other transformation operations in EA, the DDL generation process is 'closed' to us poor users. We don't have any way to even see, let alone modify, the generator.

Opening this up to developers is an often-requested feature, but apparently has not reached critical mass. Perhaps you'd like to add your voice to those already crying out for this. Use the Feature Request link below the Support link near the bottom of any forum page.

Sorry this was not better news.

David

[edit]See Simon's post below. I may be talking about something else.[/edit]
« Last Edit: July 09, 2008, 09:54:12 am by Midnight »
No, you can't have it!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: creating indexes
« Reply #2 on: July 09, 2008, 08:14:14 am »
If you're talking about DDL transformation, and not the DDL generation.  You should be able to do it by generating a method stereotyped as index on the the appropriate table.

Sorry, I can't give more information at the moment.