Home » Other » Training & Certification » SQL tips?
SQL tips? [message #173674] Tue, 23 May 2006 23:06 Go to next message
appsoracle
Messages: 2
Registered: May 2006
Junior Member
Efficient SQL Queries
Re: Efficient SQL Queries [message #173683 is a reply to message #173674] Wed, 24 May 2006 00:29 Go to previous messageGo to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member

Very good document. thanks.
Re: Efficient SQL Queries [message #174281 is a reply to message #173683] Sat, 27 May 2006 03:17 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
manwadkar wrote on Wed, 24 May 2006 07:29

Very good document. thanks.

I don't think so: it is outdated, inaccurate and contains flaws. It's not terrible but I wouldn't call it a 'very good' document.

myth number one

Contrary to popular belief COUNT(*) is faster than count(1). If the rows are being returned via an index, counting the indexed column - for example count(EMPNO) is faster still.

http://www.orafaq.com/forum/fa/449/0/http://www.orafaq.com/forum/fa/449/0/Where did you find this document? http://www.orafaq.com/forum/fa/449/0/

myth number two

51. Use explicit cursors
When implicit cursors are used, two calls are made to the database:,once to fetch the record and then to check for the TOO MANY ROWS exception. Explicit cursors prevent that second call.
Implying that explicit cursors are faster...

I hope you didn't write it yourself.

Moved to training and certification.

MHE

[Updated on: Sat, 27 May 2006 03:17]

Report message to a moderator

icon2.gif  SQL Performance [message #174413 is a reply to message #173674] Mon, 29 May 2006 03:56 Go to previous messageGo to next message
xmen.xmen
Messages: 1
Registered: May 2006
Junior Member
SQL Performance

[mod-edit]removed redundant attachment.

[Updated on: Mon, 29 May 2006 04:25] by Moderator

Report message to a moderator

Re: SQL Performance [message #174425 is a reply to message #174413] Mon, 29 May 2006 04:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please stop posting and reposting this document. It contains some useful information, but also errors and statements that generalize and don't always hold.
Besides, it was posted in some other forums already.
Re: SQL Performance [message #174431 is a reply to message #174425] Mon, 29 May 2006 04:18 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
It's appsoracle again. Let's close it.

MHE

Moved to Training&Certification.

[Updated on: Mon, 29 May 2006 04:23]

Report message to a moderator

Previous Topic: Oracle EBS 11i Materials
Next Topic: FREE Workshop on ORACLE DEVELOPER (Bangalore, India)
Goto Forum:
  


Current Time: Tue Jul 07 05:35:35 CDT 2020