Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE BadStatistics (
- IsArchived BIT NOT NULL
- ,Id INT NOT NULL IDENTITY PRIMARY KEY
- ,Mystery VARCHAR(200) NOT NULL
- );
- CREATE NONCLUSTERED INDEX BadIndex ON BadStatistics (IsArchived, Mystery);
- +--------------+----------------+-------------------------+
- | All density | Average Length | Columns |
- +--------------+----------------+-------------------------+
- | 0.5 | 1 | IsArchived |
- +--------------+----------------+-------------------------+
- | 4.149378E-06 | 37 | IsArchived, Mystery |
- +--------------+----------------+-------------------------+
- | 4.149378E-06 | 41 | IsArchived, Mystery, Id |
- +--------------+----------------+-------------------------+
- +--------------+------------+---------+---------------------+----------------+
- | RANGE_HI_KEY | RANGE_ROWS | EQ_ROWS | DISTINCT_RANGE_ROWS | AVG_RANGE_ROWS |
- +--------------+------------+---------+---------------------+----------------+
- | 0 | 0 | 24398 | 0 | 1 |
- +--------------+------------+---------+---------------------+----------------+
- | 1 | 0 | 216602 | 0 | 1 |
- +--------------+------------+---------+---------------------+----------------+
- +--------------+----------------+---------+
- | All density | Average Length | Columns |
- +--------------+----------------+---------+
- | 4.149378E-06 | 4 | Id |
- +--------------+----------------+---------+
- +--------------+------------+---------+---------------------+----------------+
- | RANGE_HI_KEY | RANGE_ROWS | EQ_ROWS | DISTINCT_RANGE_ROWS | AVG_RANGE_ROWS |
- +--------------+------------+---------+---------------------+----------------+
- | 1 | 0 | 1 | 0 | 1 |
- +--------------+------------+---------+---------------------+----------------+
- | 240999 | 240997 | 1 | 240997 | 1 |
- +--------------+------------+---------+---------------------+----------------+
- | 241000 | 0 | 1 | 0 | 1 |
- +--------------+------------+---------+---------------------+----------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement