Preguntas de entrevista para Sql Database Engineer

59 Preguntas de entrevista compartidas por los candidatos | sql database engineer

We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
avatar

SQL Database Administrator/Senior Developer

Entrevista realizada en Morningstar

3.8
4 abr 2011

We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??

Viendo 1 - 10 de preguntas de entrevista

Consultar preguntas de entrevista para empleos similares

Glassdoor ha recopilado 59 preguntas de entrevista e informes de entrevistas para el puesto de Sql database engineer. Prepárate la entrevista y consigue el empleo perfecto.