View previous topic :: View next topic
|
Author |
Message |
ronie305
New User
Joined: 09 May 2005 Posts: 3
|
|
|
|
Hi
I have 2 tables each having over a million rows. I need some data out of them for set up.
The problem is I have is that this data is in Production tables. How can i write gud query to that effect.
Any help will be welcome.
Ronie |
|
Back to top |
|
|
MGIndaco
Active User
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
|
|
|
|
I think that you must specify some detail about the definition of a table.
A improvement of query is even doing of a good definition of indexes!
I can reccomend you to use at the end of your query the WITH UR option to avoid a -911 or worse a -904 to the user that are reading the table. |
|
Back to top |
|
|
|