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
- April 2018 (30)
- March 2018 (61)
- February 2018 (62)
- January 2018 (53)
- December 2017 (37)
- November 2017 (43)
- October 2017 (57)
- September 2017 (46)
- August 2017 (61)
- July 2017 (52)
- June 2017 (42)
- May 2017 (53)
- April 2017 (53)
- March 2017 (68)
- February 2017 (40)
- 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)
Recent comments
12 weeks 4 days ago
24 weeks 5 days ago
29 weeks 21 hours ago
29 weeks 6 days ago
34 weeks 3 days ago
1 year 3 weeks ago
1 year 23 weeks ago
2 years 1 week ago
2 years 37 weeks ago
2 years 38 weeks ago