meta user
network profile
| bio | website | google.com/profiles/gclarkey |
|---|---|---|
| location | ||
| age | 30 | |
| visits | member for | 1 year, 7 months |
| seen | May 30 at 14:11 | |
| stats | profile views | 17 |
Software Engineer
|
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. |
|
Mar 15 |
asked | Why does it take a long time to drop a function based index in Oracle? |
|
Dec 7 |
answered | How do you show SQL executing on an Oracle database? |
|
Dec 7 |
comment |
How do you show SQL executing on an Oracle database? Great answer, thanks very much. I half figured out an answer that would suffice, but didn't have enough rep to post it, ha! Your's is much better though :) Have a tick and a +1. |
|
Dec 7 |
accepted | How do you show SQL executing on an Oracle database? |
|
Dec 6 |
asked | How do you show SQL executing on an Oracle database? |
