Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Oracle Internal
Home
+ new post
Pages
Files
About this group
Join this group
delete为什么会引起排序呢？"
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
This discussion is about page delete
flag
   5 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
delete was created by SQ_l
SQ_l  
View profile  
 More options Jan 28, 8:25 pm
From: SQ_l <liangs...@gmail.com>
Date: Wed, 28 Jan 2009 17:25:18 -0800 (PST)
Local: Wed, Jan 28 2009 8:25 pm
Subject: delete为什么会引起排序呢？"
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

Click on http://groups.google.com/group/Oracle-Internal/web/delete -
or copy & paste it into your browser's address bar if that doesn't
work.


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "Discussion on delete" by Tomas
Tomas  
View profile  
 More options Jan 31, 6:58 am
From: Tomas <housy....@gmail.com>
Date: Sat, 31 Jan 2009 03:58:30 -0800 (PST)
Local: Sat, Jan 31 2009 6:58 am
Subject: Discussion on delete
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
where object_id>0;

this causing it using index.

disable index and try again ?


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
sq l  
View profile  
 More options Feb 1, 10:15 pm
From: sq l <liangs...@gmail.com>
Date: Mon, 2 Feb 2009 11:15:02 +0800
Local: Sun, Feb 1 2009 10:15 pm
Subject: Re: Discussion on delete
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

就是想搞清楚为什么使用索引扫描后，就会引起排序呢？

2009/1/31 Tomas <housy....@gmail.com>


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Leyi Zhang (Kamus)  
View profile  
 More options Feb 2, 1:10 am
From: "Leyi Zhang (Kamus)" <kamu...@gmail.com>
Date: Mon, 2 Feb 2009 14:10:17 +0800
Local: Mon, Feb 2 2009 1:10 am
Subject: Re: Discussion on delete
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
索引扫描之后回表查询数据需要排序。
--
Kamus <kamu...@gmail.com>

Oracle8i & 9i Certified DBA from China
Oracle ACE
Visit my blog for more article: http://www.dbform.com


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tomas  
View profile  
 More options Feb 2, 9:27 pm
From: Tomas <housy....@gmail.com>
Date: Mon, 2 Feb 2009 18:27:01 -0800 (PST)
Local: Mon, Feb 2 2009 9:27 pm
Subject: Discussion on delete
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
why not using a 10053 to check what oracle do on this?

i also curious about this,  Hi Kamus, is that sorting help for
deleting or redo/undo information generation?


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google