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 ?
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.
Previous Topic: user_segments and tablesize:some thing wrong
Next Topic: indexes sql tunning
Goto Forum:
  


Current Time: Mon Nov 28 05:12:58 CST 2022