I have a database with over 12 million records that the user can run a search on, but it is taking far too long. Can anybody help me try and optimize my SQL to work fast? I can post any additional information that you may need. Thanks.