diff options
| author | mo khan <mo.khan@gmail.com> | 2020-01-31 13:21:24 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-01-31 13:21:24 -0700 |
| commit | 106d0ba7a2cd4bda3c75204d4cb1a1ffdcc810ce (patch) | |
| tree | d4511217bc9a428e20dd251dc56412c0b721ba92 /doc/unit-4.md | |
| parent | ca404e83bda4828ecd92a63b2086720d52beef59 (diff) | |
fix typo
Diffstat (limited to 'doc/unit-4.md')
| -rw-r--r-- | doc/unit-4.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/unit-4.md b/doc/unit-4.md index 2a159ac..b5bd1ba 100644 --- a/doc/unit-4.md +++ b/doc/unit-4.md @@ -331,7 +331,7 @@ Guidelines: 6. Indexes on large values is not optimal. Try to find a smaller coded value to index to represent the larger value. 7. If the key for the index is used to determine the location where the record will be stored then a surrogate key should be used. 8. Check DBMS for limits on the # of indexes on a table. (limits include # of indexes, and size of index) -9. Be careful indexes attributes that have null values. some systems don't index `null` so sequential scan is needed for `null` value. +9. Be careful of indexing attributes that have null values. some systems don't index `null` so sequential scan is needed for `null` value. ### Designing a database for optimal query performance |