What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?
- 1 Answers
- 2788 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ram Dwivedi
To force the CBO to use a specific index for a given statement, you can use the FORCE_INDEX initialization parameter in the spfile/init.ora file or ALTER SESSION command. Here's an example:
```sql
ALTER SESSION FORCE INDEX (table_name) ON (column_name);
```
This command will force the CBO to use the specified index for the given table and column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
