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 2020 (6)
- June 2020 (49)
- May 2020 (50)
- April 2020 (64)
- March 2020 (62)
- February 2020 (59)
- January 2020 (90)
- December 2019 (48)
- November 2019 (47)
- October 2019 (64)
- September 2019 (40)
- August 2019 (42)
- July 2019 (45)
- June 2019 (37)
- May 2019 (43)
- April 2019 (49)
- March 2019 (61)
- February 2019 (25)
- January 2019 (35)
- December 2018 (39)
- November 2018 (55)
- October 2018 (75)
- September 2018 (38)
- August 2018 (89)
- July 2018 (58)
- June 2018 (61)
- May 2018 (66)
- April 2018 (40)
- March 2018 (61)
- February 2018 (67)
Recent comments
2 years 23 weeks ago
2 years 35 weeks ago
2 years 39 weeks ago
2 years 40 weeks ago
2 years 45 weeks ago
3 years 14 weeks ago
3 years 34 weeks ago
4 years 12 weeks ago
4 years 48 weeks ago
4 years 48 weeks ago