Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
User Defined Function in Index....Rushmore ?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
User Defined Function in Index....Rushmore ?
Divers
Thread ID:
00131555
Message ID:
00131555
Vues:
49
Hi to all

I've created an index based on a UserDefinedFunction, index is like this:

fnMyFunction(fieldToIndex)

I do a SELECT SQL like this:

SELECT * FROM myTable WHERE fnMyFunction(fieldToIndex) = fnMyFunction(keyToSearch)

Is this query Rushmore optimizable ?

PS: I try with SYS(3054,1) and I've optimization level = none
but on a whitepaper I've found that index based on a Udf is optimizable.
SET OPTIMIZE is ON

Thanks in advance,
Renato
Renato Bertuol (EMail:renato.bertuol@elmec.it
Homepage:www.geocities.com/SiliconValley/Horizon/3216)
Elmec Informatica (URL www.elmec.it)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform