Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Getting data from the big table
I am trying to get data from the transactions table. It is huge. I was told to never join it to another table or try to make a multitalble view with it. My attemps to write a query with it as a join timeout.
What should I do. They select into a temp table and then join the temp table.
I am sure the table is indexed, is there a way of using the index to speed up queries. I will be studing indexing this weekend.
Thanks for your help
Jim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement