Database Journal
|
SQLCourse
|
SQLCourse2
Register
Help
Remember Me?
Forum
FAQ
Calendar
Forum Actions
Mark Forums Read
Quick Links
View Site Leaders
Who's Online
What's New?
Advertiser Disclosure
Advanced Search
Forum
Oracle Forums
Oracle Database Administration
Speeding up Queries
If this is your first visit, be sure to check out the
FAQ
by clicking the link above. You may have to
register
before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Results 1 to 6 of 6
Thread:
Speeding up Queries
Thread Tools
Show Printable Version
Email this Page…
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
Previous Post
Next Post
06-13-2002,
04:03 AM
#4
hany
View Profile
View Forum Posts
Senior Member
Join Date
Dec 2001
Posts
320
Hi pando,
According to Couchman's using count(1) is more effecient than using count(*).
Reply With Quote
Quick Navigation
Oracle Database Administration
Top
Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Oracle Forums
Oracle Database Administration
Oracle Applications DBA
Oracle Development
Oracle Certification
Oracle : How To
Oracle Careers
Oracle Positions Available
Oracle Job Wanted
Archives
Forum Archives
Other
Feedback and Questions regarding the forums
Obfuscation Unlimited
«
Previous Thread
|
Next Thread
»
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
[VIDEO]
code is
On
HTML code is
On
Forum Rules
Click Here to Expand Forum to Full Width
Reply With Quote