| Snapshot Indexing --How to --complete [message #54678] |
Wed, 27 November 2002 04:35  |
Giri
Messages: 12
Registered: March 2002
|
Junior Member |
|
|
Can any one please advice me in the following scen..
In a complete refresh snapshot
I want the queries to use a index.
How to make the snapshot to use index?
Thanks
Giri
|
|
|
|
| Re: Snapshot Indexing --How to --complete [message #54689 is a reply to message #54678] |
Wed, 27 November 2002 14:32  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Well - it's just a query which usually runs from dbms_job. Do you know that an index is not being used? How do you know? You could try changing optimizer_goal for an interactive session and then doing a sql_tarce when you manually execute the refresh to see how that one compares. You can add the alter session (using dbms_sql) to the dbms_job entry too if necessary - but that's changing a generated dbms_job entry...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
