Improve performance on a Azure Synapse Table

$30-250 USD

Terminado

Publicado

hace casi 3 años

$30-250 USD

Pagado a la entrega

I have a table with 100 million rows in Synapse. I have a requirement to query on a part of a text column. It takes close to 30 secs to return the results in Synapse, it takes less than 10 secs for the same table in SQL server database. I need to improve the performance of this table in Synapse. This table is using Round Robin Dristribution and it has Clustered Columnstore Index on it.

Microsoft SQL Server

SQL

Database Administration

Azure

ID del proyecto: 30477433

Información sobre el proyecto

3 propuestas

Proyecto remoto

Activo hace 3 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@alexsuarez

It sounds like the issue is more with the querying of part of the text column. If we can create a derived column containing the part that needs to be queried, we can build an index on that to further increase performance. Otherwise we could create a materialized view with the part that needs to be queried and pre-process that data. I'm looking to build a repeat client base so I am willing to work with you on a fixed price basis for this project and maybe get the opportunity to work with you again.

$120 USD en 1 día

0,0

(0 comentarios)

0,0

3 freelancers están ofertando un promedio de $188 USD por este trabajo

@Gventuri

Hi, this is a common issue in Synapsis. I've done some improvements in tables in DW related about it. Some issues was related DTUs contracted or bad practices in modeling.

$222 USD en 4 días