Home » RDBMS Server » Performance Tuning » how to split the query using rowid
how to split the query using rowid [message #130233] Thu, 28 July 2005 20:55 Go to next message
confident
Messages: 28
Registered: March 2005
Junior Member
can anybody pls tell me logic to spliting the sql query by using rowid through dba_extent... my sql query reports are running for quite long time, for speed up the processt i need to split the query.. i heard it can be done through split the rowid's..

Already the query is tuned.... Data extraction is some millions of records..
query is reading most of data from single table. from that table, can we split the query through range between the rowid ?

Report message to a moderator

Re: how to split the query using rowid [message #131632 is a reply to message #130233] Mon, 08 August 2005 13:12 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
We use

Select ....
From yourtable
where rownum < somenumber;

rowid is a physical location I am told.

Report message to a moderator

Previous Topic: user_segments and tablesize:some thing wrong
Next Topic: indexes sql tunning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 16:46:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.