Home » SQL & PL/SQL » SQL & PL/SQL » About Table Structure (Oracle 10G And Oracle 8i)
About Table Structure [message #332870] Thu, 10 July 2008 00:24 Go to next message
alammas
Messages: 46
Registered: July 2008
Member
Hi,
According to table structure,How Oracle find a record in Table consisting a 500,000 total number of rows
And how oracle execute a sql statement portion wise like

Select * from cashpaymentvouchtbl
Where cpvid >'0001'
Order by cpvid;
If i divide this statement in three parts that's like that
1st "Select * from cashpaymentvouchtbl "
2nd "where cpvid >'0001'"
3rd "order by cpvid"
How oracle Execute it
-Before interprete(oracle 8i)
-Directly to C language(oracle 10g)
-How much Long where clause can be,and effect on efficiency
Re: About Table Structure [message #332872 is a reply to message #332870] Thu, 10 July 2008 00:27 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What we have here is a failure to communicate!
HUH?
Re: About Table Structure [message #332874 is a reply to message #332870] Thu, 10 July 2008 00:30 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Have you heard of
1) Explain Plan.
2) SGA->Buffer Cache

Search for them on google you will get to know how oracle process Statements.

Regards,
Rajat

[Updated on: Thu, 10 July 2008 00:32]

Report message to a moderator

Re: About Table Structure [message #332884 is a reply to message #332872] Thu, 10 July 2008 00:50 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
anacedent wrote on Thu, 10 July 2008 07:27
What we have here is a failure to communicate!
HUH?

Sure! I even say: ORA-03113

Regards
Michel

Previous Topic: Logic help required
Next Topic: DATE Logic
Goto Forum:
  


Current Time: Fri Dec 09 23:31:30 CST 2016

Total time taken to generate the page: 0.09093 seconds