Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to set AUTOTRACE ON at startup??
Dear all, do you know how to set: AUTOTRACE ON EXPLAIN STATISTICS during startup!?- 011179
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
How can I obtain the execution plan of a SQL statement?
one more question: do you know how to set: AUTOTRACE ON EXPLAIN STATISTICS during startup!?- 011179
- Post #4
- Forum: Oracle: All versions
-
How can I obtain the execution plan of a SQL statement?
Thank you very much!- 011179
- Post #3
- Forum: Oracle: All versions
-
How can I know the execution plan of a SQL statement?
Thank you very much! -
How can I obtain the execution plan of a SQL statement?
Dear all, I would like to obtain the execution plan of SQL statement in Oracle! How can I do that?! Thanks!- 011179
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
How can I know the execution plan of a SQL statement?
I know DB2 V7.2 have plan_table and EXPLAIN facility from the documentation! But I don't know how to use it and how to obtain the execution plan by using the tools! Would you mind tell me that the method to obtain the execution plan of a SQL Statement in DB2?? many thanks!! -
How can I know the execution plan of a SQL statement?
Dear All, How can I know the execution plan of a SQL statement in DB2 V7.2 ?? Thanks! -
-
How to change data type when query?
Dear all, I want to chnage a VARCHAR column into decimal when query. e.g. create table sample {id VARCAHR(10), value VARCHAR(10)) How can I query the table for value > 40 ? Thanks! -
-
How to bulk load data into DB2 V7.2 ??
My data is several files which contains many rows of INSERT statement, the total size of my files is 200mb. It is very time consume for me to execute these files. That files is generated by a data source, if the files of INSERT statement is not suitable for load into database. I can ask to...
