803 reputation
415
bio website
location Atlanta, GA
age 30
visits member for 1 year, 9 months
seen Apr 10 at 17:34

Oracle DBA

Creative Director Highlands Church

Some pictures I've done


Mar
12
comment Choosing a database for big data
What kind of queries are you going to be asking it? Analytics, primary key lookups, etc
Mar
12
comment Dynamically change schema to accommodate custom fields!
EAV is a bad thing when you have better choices, it doesn't sound like you do here.
Mar
12
comment Changes access method for non-correlated subquery
Nope, I tried. Because you still have to SELECT to get the value out and the moment its a SELECT there, it seems to lose the index.
Mar
12
comment Changes access method for non-correlated subquery
Hmm I'll see if put together more of an example.
Mar
12
comment Changes access method for non-correlated subquery
Nope, same issue.
Mar
12
comment Changes access method for non-correlated subquery
Hmm i feel like I tried that, but let me test
Mar
11
revised Changes access method for non-correlated subquery
deleted 9 characters in body
Mar
11
revised Changes access method for non-correlated subquery
deleted 9 characters in body
Mar
11
asked Changes access method for non-correlated subquery
Jan
23
awarded  Notable Question
Jan
9
comment Two different databases on the same RAC cluster
No, they don't share diskgroups.
Jan
9
asked Two different databases on the same RAC cluster
Jan
7
awarded  Notable Question
Oct
30
awarded  Popular Question
Sep
3
comment Oracle specifying join order hint
Well, changing to an exists() works actually...may want to put an answer. sqlfiddle.com/#!4/d7225/17
Sep
3
comment Oracle specifying join order hint
@Phil - should be ANY(...) but still same issue
Sep
3
revised Oracle specifying join order hint
added 1 characters in body
Sep
3
asked Oracle specifying join order hint
Jul
14
awarded  Popular Question
Jul
11
awarded  Yearling