SELECT * FROM employees ORDER BY EMPLOYEE_ID OFFSET 99 ROWS FETCH NEXT

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / rutujagabhane

Answer Posted / rutujagabhane

SELECT *
FROM employees
ORDER BY EMPLOYEE_ID
OFFSET 99 ROWS
FETCH NEXT 21 ROWS ONLY;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What makes a good primary key?

1014

Is it mandatory for the primary key to be given a value when a new record is inserted?

1188

Where the sql database files are stored?

1000

Does truncate need commit?

923

how to present a past time in hours, minutes and seconds? : Sql dba

991

What are all the ddl commands?

1170

What trigger means?

967

How do you update a sql procedure?

1011

What is sql comments?

1060

what tools available for managing mysql server? : Sql dba

1063

How to disable a trigger name update_salary?

1251

What is rowid in sql?

964

What are tuples in sql?

1115

Can we use update in sql function?

1046

How many types of relationship are there?

1017