Search
Navigation
Top 60 Oracle Blogs
CURSOR_SHARING
Function-Based Indexes And CURSOR_SHARING = FORCE
In general it is known that Function-Based Indexes (FBIs) can no longer be used by the optimizer if the expression contains literals and CURSOR_SHARING = FORCE / SIMILAR (deprecated) turns those literals into bind variables.
.png){kind=small}
TweetsPopular content
Today's:
Monthly archive
- September 2017 (30)
- August 2017 (59)
- July 2017 (49)
- June 2017 (39)
- May 2017 (50)
- April 2017 (49)
- March 2017 (68)
- February 2017 (39)
- January 2017 (63)
- December 2016 (55)
- November 2016 (75)
- October 2016 (70)
- September 2016 (54)
- August 2016 (70)
- July 2016 (39)
- June 2016 (57)
- May 2016 (65)
- April 2016 (73)
- March 2016 (89)
- February 2016 (81)
- January 2016 (91)
- December 2015 (74)
- November 2015 (94)
- October 2015 (93)
- September 2015 (78)
- August 2015 (84)
- July 2015 (81)
- June 2015 (59)
- May 2015 (74)
- April 2015 (54)
Recent comments
3 weeks 6 days ago
25 weeks 19 hours ago
45 weeks 2 days ago
1 year 22 weeks ago
2 years 7 weeks ago
2 years 7 weeks ago
2 years 25 weeks ago
2 years 25 weeks ago
2 years 38 weeks ago
2 years 44 weeks ago