This method is not case sensitive and will find items regardless of the case entered. Searches are done for all instances that contain the root word or any derivative of the root word. Text default searching: When a fields search behavior defaults to the Text search method, searches are performed on fields using a complex text algorithm to determine the root of the word searched. This method is often used when extra columns are defined to maintain data but business requirements do not need users to be able to search on those fields. None default method: This method is designed to disable searching on the field it is assigned to. This approach will disable the use of indexes and is very inefficient. The same caveat applies to using this character as the first character in a search as the %. A user can enter "the animal is _ame" and the results can return, "the animal is lame" and "the animal is tame". These can be used to search for variants on a single character. Underscore characters (_) are rarely used as wildcards. This search method is the same as employing the Wildcard search method as the default search methodology for a field. Users should avoid this search method whenever possible. Indexes cannot be used with this search approach and each record from the table must be read and searched for the value. This method is the most inefficient search. If a user is searching for a record that contains "Boiler" somewhere in the field, a value of "%Boiler%" may be entered and all records where the specified column contains the word "Boiler" will be found including "Boiler", "Boilers", "Boiler is overheating", "The Boiler" and "When the Boilers are on". This method can still use indexes and will be fairly efficient though not as efficient as an Exact search. If a user is searching for a record that starts with "Boiler" a value of "Boiler%" may be entered and all records where the specified column starts with "Boiler" will be found including "Boiler", "Boilers", "Boiler is overheating". Wildcard characters include % (percent sign) and _ (underscore character). SELECT * from WORKORDER where WONUM = '123' Īdditional functionality can be included in an Exact search by including wildcards in the search criteria however, caution should be exercised when using wildcards as they can impact performance of not only the search executed but also all users using the same database. This method enables the database to analyze the SQL select statement and employ indexes to their maximum potential. Instances of "BOILER", "Boilers", "Boiler is overheating" will not be found.Įxact searching is the most efficient database search method as long as the field searched is indexed. If a user enters the value "Boiler" in an Exact field search, only records where the entire column matches the word "Boiler" will be found. This method is case sensitive and will not find items where the case of the value entered is different. Non-indexed searching is very inefficient and is triggers a Full Table Scan.Įxact default searching: When a fields search behavior defaults to Exact search method, searches are performed on fields with the exact value the user enters. If an index is not defined for a particular search or an index cannot be used, each individual record in a table must me read into memory and searched for the values. Finding records using an index is very fast and efficient, requires minimal memory, and requires minimal storage I/O. Indexes can be thought of as a sorted binary representation of the columns defined by the index. The database uses relational database technology indexing to search for records. Using these criteria, training users on the use of wildcards, and training users on how to identify Text search fields will be very powerful in attaining best performance from database searches while providing simplicity in searching.Īny search executed by Maximo generates an SQL select statement that is passed to the database server to find records. The best approach is to set all fields longer than twenty five (25) characters to Text style searching and all other character fields to Exact. If some fields are set to Exact and others to Wildcard, it will be difficult for users to remember which search type is valid in which field. To reduce user confusion, it is a best practice use search types consistently. Each field in the Maximo database can be set to employ any of these methods with the limitation of Text searching, as it does not apply to numeric columns. Maximo supports four different search methodologies: Exact, None, Text, and Wildcard.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |