13,821 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 9 months
seen 3 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Sep
21
awarded  Enlightened
Sep
21
awarded  Nice Answer
Aug
10
comment Is this SQL schema normalized according to 3NF?
Why is it important that it is specifically 3NF? If it's a design for an actual live database, performance etc is paramount, not being textbook compliant.
Aug
10
reviewed Close How do tablespaces differ in DB2 from databases in MySQL or SQL Server?
Aug
10
reviewed Close Count/Statistic for number of SHOW INDEX queries in MySQL/MariaDB 5.5
Aug
10
reviewed Close SQL where clause effect on table?
Aug
10
reviewed Close best possible index on this situation
Aug
8
comment Order by for 2 row result causes 800% performance hit
Ordering a large set is computationally expensive.
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
since when were facts and technicalities involved in this question? :)
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
Are you running on Unix? The data might be in /dev/null
Aug
7
comment What is this view being used in my query?
Jonathan Lewis to the rescue: jonathanlewis.wordpress.com/2011/02/27/internal-views
Aug
7
comment What is this view being used in my query?
Edit your question with the full query plan.
Aug
7
reviewed Close Database going to Suspect mode
Aug
7
reviewed Close mysql server is not starting
Aug
7
reviewed Close Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control?
Aug
7
reviewed Close Dropped index from view still referenced in execution plans
Aug
7
reviewed Close All MySQL databases are unavailable because of a broken table
Aug
7
reviewed Close How to apply a newly-created Domain to an existing Column?
Aug
6
comment Last few rows from a non-indexed table in Oracle
There's no silver bullet here. The Oracle end will have to submit, plain and simple (the DBAs/business owners, whatever). You need to engage with them and talk some sense. We can't really solve business issues on this site
Aug
6
comment Last few rows from a non-indexed table in Oracle
@Jon true, but that would become stale. He'd still have to tablescan many gigabytes.