PROBLEM
Clicking the Option button on an open attribute table of a geodatabase view, loaded in ArcMap, may show the Select by Attributes option disabled.
The option is disabled because the view does not have an Object-ID type column. Tables that do not have an Object-ID type column disable the Select by Attributes option.
Registering the view with the geodatabase enables the Select by Attribute option:
Note: Tables with a column name of ObjectID may not necessarily be an Object ID type. You can verify this in ArcCatalog by right-clicking the layer, selecting Properties, and selecting the Fields Tab in the Table Properties Dialog window. If you don't see the Data Type value listed as ObjectID (Integer, number, etc.) the Select by Attributes option will be disabled.
Get help from ArcGIS experts
Download the Esri Support App