Search Results

Search: Posts Made By: jim mcnamara
Forum: UNIX and Linux Applications 08-04-2007
7,511
Posted By jim mcnamara
Look - the query has to search the ENTIRE output...
Look - the query has to search the ENTIRE output of the IN (SELECT ..)
for each set of rows it deletes. I know that rowid's are what you get from an index.

Instead of me going on about this -...
Forum: UNIX and Linux Applications 08-03-2007
7,511
Posted By jim mcnamara
rowid is not an indexed column - it is a...
rowid is not an indexed column - it is a "pseudocolumn'. the in () subselect will read thru the entire select statement's result set each time. When I get back in a while I'll write something that...
Showing results 1 to 2 of 2

 
All times are GMT -4. The time now is 07:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy