Hi everyone!

I have a question about performance: I'm designing a table (Table1), and it has association with another table (Table2). Table2 can be considered a static table, 'cause its information are never changed. I was thinking about it: Is it good to have a static table on my database, or should I use some other way to get this information? I wouldn't like to have this information in my code...

ps.: this 'static table' is something like ACTIVE/IINACTIVE information (state or something like that...).

Thanks in advance...

[]s
LISS

For design-time information which is immutable, I use Java annotations. You can set up your own annotation classes, and have initialize all the data in your code.

We have a whole API set up using metadata about our application design which is annotated into the application.