Welcome to Sign in | Help

Re: Interogare mai ciudata

  •  12-16-2010, 5:05 PM

    Re: Interogare mai ciudata

    Nu cred ca performanta obtinuta ar fi mai buna. As merge totusi pe tip de date numerice. Eventual o coloana calculata (persistata) de tip integer pe care sa stocati col1 + 2^4 * col2 + 2^8 * col3 + 2^12 * col4 ....
    Ar mai eficienta filtrarea WHERE colcalculata = valoare in cazul adaugarii unui index pe colcalculata.

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems