Tips for Basic Select Queries

[Computer_Freak]

Select queries are normally used for retrieving data from a specific table. The criteria is set for selecting the data from the specific table. For getting the best result from the queries you must set the specific properties.
The below figure will give you idea about setting the query properties.

Now let us discuss about the detail of the queries.
Description
As the name suggest this property is used for describing the purpose of the query this property is normally used by the query designer for remembering the purpose of the query.
Default View
This property is used to view the data in the data sheet like table.
Output All Fields
Normally this option is set to “No” because if this option is set to “Yes” then it will display all the fields of the table.

Top Values
This option is useful for retrieving the first top ten or “N” number of records this option is better because retrieving the whole data will take more time.
Unique Values
Normally this record work as the “select distinct” command of the queries. Normally this option is set to “NO”, but if the user prefers it can be set to “Yes”

Unique Records
This option work as the “distinct rows” in sql statement. This option is also set to “No” by default but if the user prefers it can be set to “yes”

[FlashX]

You have to also consider the SQL server properties for the better performance of queries.
Sorting option
Sorting options like “order by, filter on load, order by on load” can maximize the performance because for this you do not have to load the whole data but only the required data is needed.
Add only if necessary
You must be very careful while adding the “subdatasheet name, link fields, and size”. Using these option cost the performance of the queries. So if there is a need then only add these option. Because this will definitely affect the performance.

[ChrisUlrich]

Select the perfect criteria.
Actually the thing is that the same work can be done using the different option. So the query designer must keep in mind to select the best suited criteria for the query.
Following are the criteria types.
In place of using “< >” you can use “between”. Normally >, <, <=, >= are used for searching the data in a specific range.
Using the option of “Null” or using the option of “Is Not Null”. The selection of both the thing depends upon the type of data present.
Using the wild card characters is also a wise thing to use for that you have to choose best suited wild card for the requirement.
1. ? It is used for searching the single character
2. * It is used for searching any number of characters
3. # It is used for searching single digit
4. [..] It is used for finding the character list
5. [!..] It is used for finding the data that is not in character list