| Lyad |
Posted: Jan 29, 2007 01:41:35 PM |
Total Post: 12
Joined: Jan, 2007
|
Can anybody guide me on hints sql or pl/sql?
Thanks in advance. |
|
|
 Lyad |
| Posted: Feb 05, 2007 04:36:26 AM |  |
|
Total Post: 12
Joined: Jan, 2007
|
|
|
|
|
| Jayanta |
| Posted: Feb 05, 2007 11:41:37 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
what do u mean by "hints on sql/plsql"?
|
|
|
|
|
| Lyad |
| Posted: Feb 05, 2007 01:29:38 PM | |
|
Total Post: 12
Joined: Jan, 2007
|
Hints are basically use for bettre performance.
like /*+APPEND PARALLEL*/ is put after insert statement.
Though it looks like COMMENTED but it is not that actually.
I dont know much about that.
As much as I know I have written.
Thanks.
|
|
|
|
|
| Jayanta |
| Posted: Feb 05, 2007 01:32:48 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
try to explain the matter with an example.
|
|
|
|
|
| Lyad |
| Posted: Feb 05, 2007 01:52:37 PM | |
|
Total Post: 12
Joined: Jan, 2007
|
SELECT /*+ no_parallel(t1) no_parallel(t2) no_parallel_index(t1) no_parallel_index(t2)
ordered use_nl(t2) index(t1 t1_abc) index(t2 t2_abc) */ COUNT(*)
FROM t1, t2
WHERE t1.col1 = t2.col1;
---------------------------------------------------------------------
SELECT /*+ FIRST_ROWS(10) */ table_name FROM dba_tables
WHERE owner = 'SYS'
AND table_name LIKE '%$'
ORDER BY 1;
--------------------------------------------------------
INSERT /*+ APPEND */ INTO t
SELECT * FROM all_objects;
-------------------------------------------------------
--------
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
