Write For Us

Oracle Database Indexes: Myths, Tips and Tricks

E-Commerce Solutions SEO Solutions Marketing Solutions
275 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

admin
Published
In this tutorial, OCM John Watson will - via demonstrations - debunk these myths:
Myth #1: Oracle Database does not index NULL
Myth #2: A search that includes wildcards can't use an index if the wildcard precedes the string.
Myth #3: Oracle will not use a function-based index unless the FBI is coded in the predicate.
Myth #4: Indexes always help. The more indexes the better.
So, this is, in effect, several indexing best practices.
Category
Success
Sign in or sign up to post comments.
Be the first to comment