Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

We want to create an index that contains ONLY SOME VALUES of a field. What kind of index do we have to use?

For example. Assume that we have a table with1billion rows. Let name of a field is RECORD_STATUS. Number of rows for which record_status=0 is only. We want to create an index that contains only record_status=0 records. So even table has1billion records, this index will contain only rows' address.

Indexing Finance Finance Management
user-image
Question added by Fatih Sami KARAKAS , Project Manager, Senior , Tiga
Date Posted: 2017/11/02
Upvote (0) Views (1) Followers (0) Answers (0) Report Question
Be the First to Answer
Register now or log in to answer.
Write Your Answer
More Questions Like This