• sistemas_casinomnes (9/30/2014)


    Hola, tengo el sgte inconveniente con una tabla de 9000 filas, la cual en teoria no es una tabla grande, cuando se realiza un SELECT de esta tabla demora mucho.

    Tiene un indice PRIMARY KEY CLUSTERED de tipo entero autoincremental.

    Mi duda es por que demora mucho si no es una tabla con muchos registros.

    [Rough translation from Google]

    Hi, I have the drawback sgte with a table of 9000 rows, which in theory is not a large table, when a SELECT from this table takes much is done.

    It has a PRIMARY KEY CLUSTERED index of auto-increment integer.

    My question is why it takes a lot if there is a table with many records.

    9000 rows is not a large table by any definition. In general, your query should come back very quickly. If it is slow, there are many things that could be causing it.

    You would need to post DDL for the table, some test data, your query and the execution plan from your slow query to even begin to start to guess at the cause of the slowness.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/