creating view to select unique records
- From: "setsun@xxxxxxxxx" <setsun@xxxxxxxxx>
- Date: Thu, 31 Jan 2008 07:41:14 -0800 (PST)
Hello All,
I am unsure if similar question has already been posted to this group.
If so please point me to the relevant post/group.. otherwise please
read on...
We are in the process of migrating our application from Sybase to
Oracle. Basically for each table, we would do an bcp out of the table
and load it into oracle via sqlldr.
The source table has duplicate rows in it. However, we would not want
to export those dupe rows to our oracle table.
My intention is to create a view that would pick up only the unique
records and I can bcp the data out of the view.
I can create a view something like
select distict * from sybase_table. However, I am worried about the
performance since I have heard that distinct clause is a costly
operation ( I am working on about 120-140 million rows ).
Is there a better way to achieve it?
Thanks in advance
Arun
.
- Follow-Ups:
- Re: creating view to select unique records
- From: jefftyzzer
- Re: creating view to select unique records
- Prev by Date: Re: Select into problem
- Next by Date: Re: Any equivalent of LIST() function in ADS?
- Previous by thread: Where is the jconn3.jar (and/or a downloadable jconnect) ?
- Next by thread: Re: creating view to select unique records
- Index(es):
Relevant Pages
|
