Re: Hiding hint in SQL from SQL Trace?
- From: "William Robertson" <william.robertson@xxxxxxxxxxx>
- Date: 29 Sep 2005 15:47:07 -0700
enrikonewsgro...@xxxxxxxxxxxxx wrote:
> I have an ETL application that allows you to select a table delivery
> method, one of which is APPEND. When I select this option and turn on
> sql trace to watch the sql being generated there is no /*+ APPEND */
> hint in the INSERT statement.
> The application is written in C/C++.
>
> Is it possible to hide a hint from sql trace?
Are you sure it is supposed to do an INSERT /*+ APPEND */?
Perhaps it just means APPEND as opposed to REPLACE, i.e. don't delete
the existing data before loading?
.
- References:
- Hiding hint in SQL from SQL Trace?
- From: enrikonewsgroups
- Hiding hint in SQL from SQL Trace?
- Prev by Date: 10G r2 Scheduler
- Next by Date: Partition Drops is effecting performance adversely...
- Previous by thread: Hiding hint in SQL from SQL Trace?
- Next by thread: 10G r2 Scheduler
- Index(es):
Relevant Pages
|
