Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timing a query

Status
Not open for further replies.
mbames

mbames

Programmer
Jun 5, 2003
29
GB
Is there an easy way to time how long a query takes? For instance I have a table with 1/2 million test records (each is unique). Part of each record contains an XMLType, and I need to show that searching in an XMLType is slow... and that we should be splitting out certain fields from the XML data and indexing them in order to have a fast search...

Or an I going to have to sit here with a stopwatch?!

Cheers,
Matt
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
345
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
411
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
434
SkipVought
S
George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
387
carp
carp
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
131
Olutee360
Olutee360

Part and Inventory Search

Sponsor

Back
Top