OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » SQL tips?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL tips? [message #173674]

Tue, 23 May 2006 23:06

appsoracle
Messages: 2
Registered: May 2006

Junior Member

Efficient SQL Queries

Attachment: SQL Performance.pdf
(Size: 110.48KB, Downloaded 2710 times)

Report message to a moderator

Re: Efficient SQL Queries [message #173683 is a reply to message #173674]

Wed, 24 May 2006 00:29

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

Very good document. thanks.

Report message to a moderator

Re: Efficient SQL Queries [message #174281 is a reply to message #173683]

Sat, 27 May 2006 03:17

Maaher
Messages: 7065
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.

Where did you find this document?

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

SQL Performance [message #174413 is a reply to message #173674]

Mon, 29 May 2006 03:56

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

Frank
Messages: 7901
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.

Report message to a moderator

Re: SQL Performance [message #174431 is a reply to message #174425]

Mon, 29 May 2006 04:18

Maaher
Messages: 7065
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:45:04 CDT 2024