14,031 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 11 months
seen 2 days ago

Oracle DBA, Unix admin.

Available for employment! ;)


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.
Aug
6
comment Last few rows from a non-indexed table in Oracle
Not much you can do without an index. Are you allowed to put an AFTER INSERT trigger on the big table? You could use that to populate a smaller indexed table.
Aug
6
comment Last few rows from a non-indexed table in Oracle
What does "last few rows" mean? There is no ordering in your query, which makes the question meaningless.
Aug
6
reviewed Close Why do sys.columns and INFORMATION_SCHEMA.COLUMNS display different number of columns
Aug
6
reviewed Close Create Meaningful Visualization for Large Set of Tables
Aug
6
reviewed Close Feature comparison: Oracle Database and Microsoft SQL Server
Aug
6
reviewed Close MYSQL Query - Unexpected result in text messaging database