Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number Index Vs Varchar2 index
Message
De
29/05/2001 02:57:01
 
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00510940
Message ID:
00512079
Vues:
15
That's interesting.
What is the exact precision of each column. How did you put the data in?
Can you give a sample of each index values.


Likely the second query has been found in the DB cache (memory).

I.E. You found it in the first query and stored it in the cache then the second query just pulled the row direct from the cache without any disk access.

You need to reverse the order of the queries after dropping and reimporting the
table and clearing the cache.

The size of the index and differences (or non-differences ) in the data matter also.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform