1. List the field you want to query when you write the SQL statement, try not to use * instead, for example: select col1, col2, col3 from Table without select * from table2. Use TOP when the amount of data is large. Search 3. Establish an index for some key fields, and some combined index 4. Create a file group, the key is to map the file group to the hard disk, preferably use a separate disk controller. This will improve access.
Speed. Index is also a truth. When there are two hard drives, corresponding two file groups, put the table in a file group, put the index in another
In the file group, this will also increase the speed of access .5. Full text Search for search for complex articles level, simple search Like is more appropriate 6. Generally, in and OR is relatively slow. To write to exisss or AND.
