226 reputation
259
bio website google.com/profiles/gclarkey
location
age 31
visits member for 2 years, 9 months
seen Jul 4 at 10:30

Software Engineer


Jul
2
awarded  Curious
Apr
1
awarded  Notable Question
Jan
20
awarded  Famous Question
Aug
8
awarded  Famous Question
Jul
12
awarded  Yearling
May
23
awarded  Caucus
May
23
awarded  Constituent
May
12
awarded  Notable Question
Mar
31
awarded  Popular Question
Feb
28
awarded  Popular Question
Feb
18
awarded  Popular Question
Feb
12
awarded  Notable Question
Nov
25
awarded  Popular Question
Sep
5
accepted Modelling Relationships in an E-R Diagram, Table or Foreign Key?
Sep
5
comment Modelling Relationships in an E-R Diagram, Table or Foreign Key?
Of course, it depends on the relationship! I can't believe I overlooked it. The best answers are always simple. For n..n, have the relationship as a table, but for guaranteed n..1 or 1..n, have it as a foreign key.
Sep
5
asked Modelling Relationships in an E-R Diagram, Table or Foreign Key?
Jul
25
asked Why won't Oracle alter the size of a column that is used for sub partitioning?
Mar
20
comment Why does it take a long time to drop a function based index in Oracle?
Ditto on the lack of knowledge on the virtual columns. Thanks very much for the answer!
Mar
20
accepted Why does it take a long time to drop a function based index in Oracle?
Mar
16
comment Why does it take a long time to drop a function based index in Oracle?
According to this: forums.oracle.com/forums/thread.jspa?threadID=541834 I would have expected a resource busy error if it was locked? Also, I have another index which is similar, and if I try to drop both at the same time, I do get that error while dropping the second index. This implies to me that the "drop index" has got the lock it requires, and is just taking its time.