4,182 reputation
21123
bio website stackoverflow.com/users/…
location France
age 37
visits member for 2 years, 11 months
seen 8 hours ago

“Well!... That takes the biscuit!”

Joyce, James. The Dubliners

The best way to speed up something is to not do it in the first place.

Kyte, Thomas.


8h
reviewed Reject suggested edit on Query Plan Different When Using Compiled Values
1d
revised InnoDB internals - checkpoint, LSN, dirty pages
added 70 characters in body
1d
comment Oracle Tablespace issue
Please do some research before asking a question. Typing that error message in google should give you lots and lots of information already. Also search for "Oracle tablespace management" to find the general overview docs.
2d
comment Index that is not used, yet influences query
If there are more statistics available (esp. cardinality and possibly min/max values) on the id column with the index than without, that could change the optimizer's group by method selection, even if it doesn't end up using the index at all. (I don't know postgres's optimizer & statistics at all, so no idea if that could be the case or not.)
2d
comment Oracle dbms_datapump removes dumpfile after succesful import
I have never seen that happen. Are you sure it's datapump and not something else in your procedure that's doing it? What version are you using?
Jul
28
revised Store n:m data with most n:1 tuples
added 2 characters in body; edited tags
Jul
28
comment Need to get the first 15 rows from 200k rows of data fast
Without seeing the actual SQL, your table definitions (including indexes), and the query plan, this is much too vague. Please edit all that information into your question.
Jul
28
revised Need to get the first 15 rows from 200k rows of data fast
It's spelled lakh, and isn't common outside some parts of Asia. You probably shouldn't use it on international sites
Jul
28
revised Help reading deadlock XML
added 8 characters in body
Jul
28
revised How does Oracle 10g use indexes?
added 46 characters in body; edited title
Jul
28
comment Oracle Triggers - Before Update and Before Insert - Separate or Combined?
Why would you want to change what you have if it works? Are you encountering problems? (9i?)
Jul
27
reviewed Edit suggested edit on How to use the dbms_sql to get the analyze for insert into statement
Jul
27
revised How to use the dbms_sql to get the analyze for insert into statement
More tags added
Jul
27
reviewed Edit suggested edit on DBMS database management system
Jul
27
revised DBMS database management system
edited grammar, added tag
Jul
27
revised Migration query taking time
added 14 characters in body; edited tags
Jul
27
reviewed Close DBMS database management system
Jul
27
reviewed Approve suggested edit on Migration query taking time
Jul
27
reviewed Approve suggested edit on Can I Create a Database and Tables in One SQL Command From PHP?
Jul
27
reviewed Edit suggested edit on RaiseError on SQL Server stored procedures