|
-
kool_max, following PAVB I would say : except on the case of test/development database, WHY you (dba) is not creating the necessary objetcs ? See, by definition a developer know NOTHING about PCTFREE, tablespaces, compression and N+1 other important things to get top performance from an object.... 99 times in 100, a developer will do a CREATE INDEX with all the options default, what NOT is always the recomended way to work....
Anyway, answering : http://asktom.oracle.com/tkyte/article1/index.html explain about FBIs, the prvs required are QUERY_REWRITE_ENABLED=TRUE and QUERY_REWRITE_INTEGRITY=TRUSTED
Regards,
Chiappa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|