Path: news.easynews.com!easynews!ps01-sjc1!news.webusenet.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.spamkiller.net!propagator2-la!propagator-la!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server Subject: Re: Mass Deletions From Tables Date: Thu, 8 Aug 2002 16:02:41 +1000 Organization: ihug ( New Zealand ) Lines: 59 Message-ID: References: <3d5206f8$0$227$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: p625-apx1.syd.ihug.com.au X-Trace: lust.ihug.co.nz 1028786506 1560 203.173.142.117 (8 Aug 2002 06:01:46 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Thu, 8 Aug 2002 06:01:46 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:157228 X-Received-Date: Wed, 07 Aug 2002 22:58:51 MST (news.easynews.com) Come on Niall.... be fair. Were I to do a 'create table blah as select * from table1 order by X', it's a fair bet that blah has records physically stored in X order. Were you to do a SQL Load from a text file generated from SQL Server (perish the thought) in a known order, then its equaly a fair bet that the table you loaded in to has those records physically stored in that order. The general point is true enough: the order of events in a table is about as ordered as the order of events in my brain. IE, not very. But it doesn't *have* to be an IOT. Regards HJR "Niall Litchfield" wrote in message news:3d5206f8$0$227$cc9e4d1f@news.dial.pipex.com... > "Stephen Ferracioli" wrote in message > news:gkg49.798$UN5.58177778@newssvr13.news.prodigy.com... > > I'm pretty sure that I am deleting the *physically* first 500 Mb. I am > loading a replacement set > > of data. BW manages data by packets. The new packets are not available to > the user until I > > delete the old packets and activate the new ones. The data is physically > stored in the sequence > > it was sorted. The "star schema" is a *logical* representation of the data > in BW. The foreign > > keys of the star schema do not have any bearing on the sequence of data in > the fact table. SAP > > uses a relational dbms but the data is accessed using a network of > pointers. Really wild stuff. > > The only way in which the data could be stored "in the sequence in which it > was sorted" would be if the tables were index organised tables. I'd be > surprised to find that this was the case. > > > -- > Niall Litchfield > Oracle DBA > Audit Commission UK > ***************************************** > Please include version and platform > and SQL where applicable > It makes life easier and increases the > likelihood of a good answer > ****************************************** > >