Hint                                                                               When Ignored

Cluster                                                               When Used with a nonclustered table

Hash                                                                   When used with a Nonclustered table

Hash_aj                                                              When no Sub_query Exists

Index                                                                  When the specified Index does not exist

index_combine                                                 When no bitmapped_indexes exist

Merge_aj                                                           When no Sub_query Exists

Push_subq                                                        When NO sub_query Exists

star                                                                     When No Proper index exists on the fact table

use_nl                                                                 When there is no index on any of the tables in Join