You are required to query an index in an Azure AI Search solution. The query needs to include syntax for sorting, filtering, and using wildcards. The query must also be optimized for performance and scalability. Describe the steps you would take to construct and execute this query, ensuring it meets the requirements for sorting, filtering, wildcard usage, and performance and scalability.