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
- July 2017 (38)
- 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)
- March 2015 (59)
- February 2015 (58)
Recent comments
36 weeks 6 days ago
1 year 14 weeks ago
1 year 50 weeks ago
1 year 51 weeks ago
2 years 16 weeks ago
2 years 16 weeks ago
2 years 30 weeks ago
2 years 35 weeks ago
2 years 36 weeks ago
2 years 37 weeks ago