Search of records

Search of the record satisfying certain conditions, means transition onto the given record. Search in many respects is similar to filtering, during search the check of records fields also is carried out. Difference consists that as a result of search the quantity of data set records does not change, and transition onto the found record is carried out.

At the organization of records search the great value has presence of index for fields by which search is conducted. At use of indexes the speed of data processing considerably raises.