Delete

You are not logged in or registered. Please login or register to use the full functionality of this SYBASETEAM.COM Website...

Current time: 09-09-2010, 05:23 AM Hello There, Guest! (Login — Register)

Page: 1

Results : Delete
Thread / Author	Tags
Delete Rows From Huge Table - foo	Table, Huge, From, Rows, Delete,
I have a large table with 13 millions rows of records, with one non-clustered index REF_DATA_IDX on REF_DATA. However, when try to delete portion of the rows, Error 1204 (Running out of LOCKS) occurs. delete from DBSample..LARGE_TABLE where REF_DATA = 123 What is the best way to perform deletion from a large table?

Similar Thread Tags

INSERT new rows into a TABLE with SELECT in Sybase ASE, Saving space when inserting rows monotonically in Sybase, How do I remove duplicate rows from a table in Sybase ASE?, How to quickly delete all rows from a table without filling up the transaction log?, remove rows affected and dashes in sybase isql output or results, Sybase ASE demand grows 30%, Duplicate rows in sysusers??, New Sybase interview questions from IT Acumens, Urgent from Sybase: Backup Server Will Not Start on solaris, DDL for master..syslogins (Migrate syslogins from Sybase 12.0 to Sybase 12.5), T-SQL: A Simple Way to Build a String from a Column, 9 Rules of Innovation from Google, Nagendra from Bangalore, Kishor from Hyderabad, Sybase FAQs from ISUG(International Sybase User Group) Site, Tools for determining the sizes of tables and indexes,usage,advantages,disadvantages, ISUG Audio and PDF Presentations on MDA Tables in sybase :Tips and Tricks, SQL script to calculate the size of the Stable Queues, want to share information on : Types and uses of temporary tables in sybase, MDA Tables in Sybase - Tips and Tricks by ISUG ,pdf document on mda tables attached., MDA or Monitoring tables in ASE, sysdevices and sysusages tables' changes in sybase ase 15, Sybase Adaptive Server Enterprise System Tables Diagram,

Simple TagCloud Plugin by Kupo v 0.6g - CS

Page: 1

Contact Us | SybaseTeam | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication

Pharmaboard Plugins, Powered By SybaseTeam
Copyright © 2002-2010 MyBB Group