Skip to content

Commit fe37b04

Browse files
authored
Add bullet points for filter predicate examples
1 parent 98ebdbf commit fe37b04

1 file changed

Lines changed: 3 additions & 3 deletions

File tree

docs/t-sql/statements/create-index-transact-sql.md

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -264,11 +264,11 @@ CREATE [ CLUSTERED | NONCLUSTERED ] INDEX index_name
264264

265265
Here are some examples of filter predicates for the `Production.BillOfMaterials` table:
266266

267-
`WHERE StartDate > '20000101' AND EndDate <= '20000630'`
267+
* `WHERE StartDate > '20000101' AND EndDate <= '20000630'`
268268

269-
`WHERE ComponentID IN (533, 324, 753)`
269+
* `WHERE ComponentID IN (533, 324, 753)`
270270

271-
`WHERE StartDate IN ('20000404', '20000905') AND EndDate IS NOT NULL`
271+
* `WHERE StartDate IN ('20000404', '20000905') AND EndDate IS NOT NULL`
272272

273273
Filtered indexes do not apply to XML indexes and full-text indexes. For UNIQUE indexes, only the selected rows must have unique index values. Filtered indexes do not allow the IGNORE_DUP_KEY option.
274274

0 commit comments

Comments
 (0)