You are required to create an index for an Azure AI Search solution. The index needs to support complex queries, including sorting, filtering, and wildcard searches. Describe the steps you would take to design and create this index, ensuring it meets the query requirements.