Displaying Indexed data from database
If Indexing on the Form has been enabled then the list may be optimized (in terms of performance) by displaying the data directly from the Index (MySQL), open the List Setting, navigate to the Basic Details section and set the SQL View field as checked.
Click here to know more about the fields in the List Setting