Search results for query: *

Does doing a fastexport/multiload into an empty table perform faster than an insert/select into an empty table?

In trying to clean up a test database, I've discovered a join index with no name on one of the tables. Does anyone know how to drop this index? I've tried drop join index but since it doesn't have a name, I'm stumped. Thanks for any help.

From reading the manuals, I gather that order by hash and order by values clauses on indexes help when querying a range of values. Or am I totally off base here? So I have a table with a UPI - one column numeric. A colleague of mine added a NUSI on the same column with the order by hash...

In the following stored procedure I have the table t_lookup_changes_temp defined as a perm table and the procedure works. When I try to define the table as global temporary, the procedure runs but does nothing. Any ideas? I'd like to use global temp because I may have several procedures...

Why, when you add referential integrity to a table and there are no errors, doesn't the system table get dropped. It's confusing - it always makes me think there are errors. Just curious.

I'm trying to compile a stored proc which contains a cursor. When I compile the procedure in queryman, it doesn't give me error messages. Here the procedure - any help would be appreciated: Replace PROCEDURE ncr_temp.spCpaisUpdate( ) BEGIN --...

I need to update rows in a large (100 million rows) table. The number of rows that will be changed is relatively small compared to the size of the table - my guess is that no more than 2-3% will be updated at any one time. Does anyone know of a fast way to do this other than with update statements?